Technical Blog Post
Abstract
Resolving maximo db2 database error : “The transaction log for the database is full..”
Body
This error has an error code SQLCODE=-964, SQLSTATE=57011, DRIVER=4.11.69."
and means the space issue with db2 logs due to large number of transactions.
To overcome the problem , please run the fallowing statements
changing to number specified is usually sufficient enough for medium work load
db2 UPDATE DB CFG FOR <DBNAME> USING LOGSECOND 80;
db2 UPDATE DB CFG FOR <DBNAME> USING LOGPRIMARY 120;
db2 UPDATE DB CFG FOR <DBNAME> USING LOGFILSIZ 4096;
DB2STOP ;
DB2START;
Please take in configuration that sum of LOGSECOND + LOGPRIMARY <= 256 and
LOGFILSIZ is a number of 4 K pages , and could up to 20000.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
UID
ibm11131417