I am trying to insert large amount of data to DB2v8.1 using JDBC connection. I am getting DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011. I have looked around everywhere for this error, but it seems like no one has reported this problem. I hope anyone out there can help me to idetnify this problem and solution?
I did not have problem when i was trying to insert smaller amount of data.
Originally posted by sathyaram_s
There are two db cfg parms, LOGPRIMARY and LOGSECOND..
If I remember right, setting LOGSECOND=-1, you will not have the log full condition ...
I do not think it will work, at least in v7
update db cfg for test using LOGSECOND -1
SQL0104N An unexpected token "-1" was found following "LOGSECOND". Expected
tokens may include: "<unsigned-short-number>". SQLSTATE=42601
In v7, if you want to increase log file size, there are 3 parameters to play with: logprimary, logsecond and logfilsiz.
The total log file size limit is 32 GB. That is, the number of log files (logprimary + logsecond) multiplied by the size of each log file in bytes (logfilsiz * 4096) must be less than 32 GB.
I do recommend you switch to more frequent commits or use load