Resolving maximo db2 database error : “The transaction log for the database is full..”
eugenebibm 310000095V Visits (9601)
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;
Please take in configuration that sum of LOGSECOND + LOGPRIMARY <= 256 and
LOGFILSIZ is a number of 4 K pages , and could up to 20000.