The destruction of the DB2-964 issue is simple!

Source: Internet
Author: User

This article describes the correct solution to the DB2-964 issue. If you are curious about the correct solution to the DB2-964 issue, the following articles will unveil its mysteries. The following is a detailed description of the relevant content, hoping to help you in this regard.

 
 
  1. 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 | 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 Using

"

Modify the log file size: db2 "update db cfg Using LOGFILSIZ 4096"

Modify the number of master log files: db2 "update db cfg Using LOGPRIMARY 6"

Modify the number of auxiliary log files: db2 "update db cfg Using LOGSECOND 10"

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.