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

DB2 in the execution of a large insert/update operation "The transaction log for the ' database is full. "Error, check the document is DB2 's log file is full."

Run the following command first to view DB2 log configuration information

$ DB2 Get DB CFG | grep LOG

Note that the following configuration items

Log file Size (4KB)                         (LOGFILSIZ) = 1024 number of
primary log files                (LOGPRIMARY) = number of
secondary L og files               (LOGSECOND) = 20

At this point, you can modify the B2 log configuration information by using the following command

$ DB2 Update db CFG using LOGFILSIZ 10240
$ DB2 update db CFG using LOGPRIMARY
$ DB2 update db CFG using LOGSE COND 100

You need to restart the database instance after modifying the configuration

$ db2stop Force
$ db2start

Finally, review the modified parameters again, and then rerun the insert/update operation.