Hi,

I try to load 500,000 records in to our DB2 UDB Dev region(Ver 8.1) using load client utility. But i get the following error msg while doing it :

"SQL0964C The transaction log for the database is full. SQLSTATE=57011"

Can anyone help me in resolving this issue. Appreciate if necessary commands are also sent

Thanks,
Arunvijay

The LOAD command should not be using the transaction log. What is the command you are using? Also what OS is the DB2 server on?

Andy

i use the following command :

db2 connect to dezwt01s user db2inst using test
db2 load client from /data/db2/db2inst/Daily_Trx_1 of del modified by delprioritychar coldel~ usedefaults MESSAGES /data/db2/db2inst/Daily_trx1.log insert into db2dba.Daily_trx_sale_cmsn_fact_1;
db2 terminate ;

it is Unix OS

You can add the "SAVECOUNT n" clause that might fix what you are doing.

Andy

If it is a log issue increase primary or secondary logs or set LOGSECOND to -1 to enable infinite logging

add nonrecoverable to end of the load statement = no logging...

it is working fine now..thanks all for ur replies

Can you please let us know which of the proposed solutions did help to solve the problem, thanks Piet

piet
nonrecoveable at the end would have solved the problem,
przytula,
incase the table was already having the data and was having constraint on it even using
nonrecovable options will load insert it deletes and use the log for dat, please correct me on this i may be wrong.
arun
was dat the issue ??

I will go for the non recoverable option, cheers, Piet

hello sir,

as u suggested nonrecoverable = no logging, incase we don't u this options "nonrecoverable" does it writes to log file while load ?? i believe it won't coz it ask for backup. please correct
Regds
Paul

what is the command used?

Take a look at Load command

hi bella,
u mean load without nonrecoverable option does log's minimal amt of logging is done.
regds
Paul

Load is a minimal logging utility (in case of all load options - copy yes / copy no / nonrecoverable). The delete phase, if performed, is the only time when load can produce a substantial number of log records.