var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Transaction log is full
iīve got some problems while loading a table on DB2(9.7 FP2).
The command looks like similar to this one:
LOAD CLIENT FROM "data.csv" OF DEL MODIFIED BY COLDEL0x09 METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9) MESSAGES "logs.txt" REPLACE INTO SCHEMA.TABLE (1, 3, 2, 5, 4, 7, 6, 9, 8) NONRECOVERABLE
This command always failed with the message: "The transaction log for the database is full"
I donīt understand this, because the Option NONRECOVERABLE is set.
Why did this happen?
To prevent this error i could increase the logfilesize (LOGFILSIZ, LOGPRIMARY, LOGSECOND), but i donīt want to do that.
What can i do there?
Do you see load performing a delete phase?
See this thread for some information:
the load is performing a delete:
2011-05-04-08.50.04.921229+120 I295585E545 LEVEL: Warning
PID : 2977 TID : 140625332660560PROC : db2sysc 0
INSTANCE: xxxxx NODE : 000 DB : xxxxx
APPHDL : 0-4930 APPID: xxxxx
AUTHID : xxxxx
EDUID : 129 EDUNAME: db2agent (xxxxx) 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 101 bytes
LOADID: 129.2011-05-04-08.49.42.998852.0 (3;3)
Starting DELETE phase at 2011-05-04 08.50.04.921137.
Correct your input file so that db2 doesn't have to execute this phase.
Hmm.... would it help to bring the columns in the correct position?
No, it would not. During the DELETE phase duplicate rows (those that violate unique constraints on the table) are being deleted. Remove duplicate rows from the input file.