DB2 "Thetransactionlogforthedatabaseisfull" Problem and Solution
DB2 reports "The transaction log for the database is full .. "error. I checked the document because the DB2 log file is full.
First, run the following command to view the log configuration information of DB2.
$ Db2 get db cfg | grep LOG
Note the following configuration items
Log file size (4 kb) (LOGFILSIZ) = 1024 Number of primary log files (LOGPRIMARY) = 45 Number of secondary log files (LOGSECOND) = 20 at this time, you can use the following command to modify the log configuration information of B2.
$ Db2 update db cfg using LOGFILSIZ 10240 $ db2 update db cfg using LOGPRIMARY 100 $ db2 update db cfg using LOGSECOND 100 restart the database instance after the configuration is modified
$ Db2stop force $ db2start check the modified parameters again and run the insert/update operation again.