SQL Error: SQLCODE=-964, SQLSTATE=57011 and ETL job fails
Running workitem job fails with the following errors in the logs, after enabling debug logging for ETL:
***
CRJAZ0265E The database resource or virtual storage is not available.
SQL: INSERT INTO "RICALM"."REQUEST_BASELINE" ("REQUEST_HISTORY_ID", "REC_DATETIME") VALUES (?, ?)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.14.121
SQL State: 57011
Error Code: -964
***
How to resolve this?
One answer
--> Based on the DB2 error, it most likely was that the DB2 transaction log was filled up:
https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.messages.sql.doc%2Fdoc%2Fmsql00964c.html&resultof%3D%2522%252d%2539%2536%2534%2522%2520%2522%2539%2536%2534%2522%2520
After increasing the log file size, the ETL jobs started running fine without errors.
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.spatial.doc%2Fcfgtranslog.html
In my case, increasing the logprimary and logsecond resolved the DB2 errors
One should check the LOGFILESIZ, LOGPRIMARY and LOGSECOND values, and increase them.
Then run the ETL.