Case study of full DB2 database transaction log

One afternoon, the development report said that when the DML operation was executed, the database reported an error where the transaction log was full. The specific information is as follows: $ db2deletefromtzsdb01DB21034E this command is processed as an SQL statement because it is not valid

One afternoon, the development report said that when the DML operation was executed, the database reported an error where the transaction log was full. The specific information is as follows: $ db2deletefromtzsdb01DB21034E this command is processed as an SQL statement because it is not valid

Number of primary log files (LOGPRIMARY) = 10
Number of secondary log files (LOGSECOND) = 4
Changed path to log files (NEWLOGPATH) =
Path to log files =/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/

This article is from the "Drip Stone" blog, Hong Kong Server rental, Hong Kong server, please be sure to keep this source

, Hong Kong VM