Quick Solution for errors reported when db2's bufferpool is insufficient

The DB2 database reports "DB2DatabaseError: ERROR [57011] [IBM] [DB2NT] sql1218ntherearenopagescur1_lyavailableinbufferpool4096. SQLSTATE57011" when importing tables in batches ".

The DB2 database reports "DB2DatabaseError: ERROR [57011] [IBM] [DB2/NT] sql1218ntherearenopagescur1_lyavailableinbufferpool4096. SQLSTATE = 57011" when importing tables in batches ".

The DB2 Database reports "DB2 Database Error: ERROR [57011] [IBM] [DB2/NT] SQL1218N There are no pages currently available in bufferpool" 4096 "when importing tables in batches ". SQLSTATE = 57011 ". Note that this error is obviously caused by insufficient bufferpool.

The solution is different. You need to increase the log file size, the number of log files, and the number of auxiliary log files.

Command for viewing configuration parameters: db2 get db cfg ;

Command for modifying configuration parameters:

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 20
Modify the number of auxiliary log files: db2 update db cfg Using LOGSECOND 10

The sum of the primary log and secondary log cannot exceed 255

After modifying the log configuration, if the database is in use, you need to restart the database (db2stop force, db2start), and then connect to the database (db2 connect ), When connecting to the database, the data will spend a little time allocating new logs. It will take some time.

In fact, the error 57011 may be caused by insufficient disk space on the machine. You can clear the disk space and drop useless instances.

This article is from the blog "dishui Tong Shi Sun Jie". Please keep this source