DB2 "The transaction log for the database is full" problem and solution, db2transaction

DB2 "The transaction log for the database is full" problem and solution, db2transaction

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

In this case, 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

After modifying the configuration, You need to restart the database instance.

$ Db2stop force $ db2start

Finally, view the modified parameters again and run the insert/update operation again.