473,408 Members | 2,402 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

SQL3522N error for Load command

Hi All
I am using db2 8.2 on a Suse Enterprise linux 9. I am setting up new db for a project. I created tables and when I was going to load test data, I got the
SQL3522 error - 'log retain and user exits should be enabled to give a copy target in a load command'. My ;log retain is set to RECOVERY and logarchmeth1 has a TSM path to it. After some hours, I saw the log files were actually archived there, by querying the TSM node, but this error comes up everytime I use a copy yes.

And I did backup, restart db after I changed the logging parameters.

Any suggestions would be welcome, this is just frustrating.
thanks
Arun
Apr 2 '07 #1
0 1750

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: MrTulley | last post by:
UDB V8 FP4 AIX 5.1 I am receiving the following error message while using the autoloader to load a pipe delimited file into a partitioned table: SQL3004N The filetype parameter is not valid....
7
by: Eric.Jones | last post by:
I've encountered a strange error with loading delimited files from a Samba (SMB) network drive, has anyone else seen this before? (Platform: WinXP Pro, UDB PE 8015, level 02060106, SAMPLE db) ...
1
by: Mark | last post by:
I get the following error (see stacktrace) while loading an XMLDocument. The document is huge and it has PI's created from Arbortext's editor. Works fine when I use MSXML2 to load the Document....
3
by: Adriano | last post by:
Hello, when I try to print something, either DataGrid or from Crystal Report viever the folowing error message appears and cancels printing: Object reference not set to an instance of an...
3
by: db2udbgirl | last post by:
Env: DB2 UDB 8.2, AIX 5.3 While trying to load data (73 Million rows, Medium size table uses 4K tablespace) into a table using cursor it fails with "SQL0964C The transaction log for the database...
3
by: Doug Durrett | last post by:
I'm having an issue and wanted to pass it by everyone to see what you think. Here is my code. //Code Start searchs = new...
0
by: JPrichard | last post by:
I searched for this topic and already read this article: http://www.thescripts.com/forum/thread183687.html However while I wait for the DBA's here to respond to my e-mail, I wanted to make a...
2
by: contractsup | last post by:
Environment: $ uname -a AIX <withheld2 5 000100614C00 $ db2level DB21085I Instance "<withheld>" uses "32" bits and DB2 code release "SQL08024" with level identifier "03050106"....
0
by: msheikh25 | last post by:
After a failed informatica load session, when I try to select from a table it shows that the table is in Load Pending state: 1 ----------- SQL0668N Operation not allowed for reason code "3" on...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.