One of the ways to eliminate DB2-964 Problems

The following articles mainly describe the correct solution to the DB2-964 problem. If you are interested in the actual operations related to the correct solution to the DB2-964 problem, you can click to view the following articles. The following is a detailed description of the main content of the article. I hope you will have a better understanding of it after browsing.

 
 

  
  
SQLState '57011' and errorCode '-964' 
 
 

Find the reason DB2 "? SQL = 0964"

Cause: the database log file is full.

Solution: Increase the log file size), increase the number of log files, and increase the number of auxiliary log files. You can select any of the three modification parameters)

View database configuration parameters: DB2 "get db cfg for <dbname> | grep LOG"

Log File size 4 kb) (LOGFILSIZ) = 1024 the size of each log file is 1024*4 kb = 4 MB)

Number of Primary log files (LOGPRIMARY) = 3

Number of auxiliary log files (LOGSECOND) = 1

Modify database configuration parameters: DB2 "update db cfg for <dbname> using <p> <v>"

Modify the log file size: DB2 "update db cfg for <dbname> using LOGFILSIZ 4096"

Modify the number of master log files: DB2 "update db cfg for <dbname> using LOGPRIMARY 6"

Modify the number of auxiliary log files: DB2 "update db cfg for <dbname> using LOGSECOND 10"

The above content is an introduction to the solution to the DB2-964 problem. I hope you will have some gains.