DB2: There are currently no pages available in the buffer pool "1" ... sqlcode=-1218, sqlstate=57011, driver=3.61.75

Server-side DB2 database recent frequent error:

" 1 " There are currently no pages available in: sqlcode=-1218, sqlstate=57011, driver=3.61.  the

The experiment found that simple query SQL execution is not a problem, the complex SQL will report the above error.

Baidu found because the database bufferpool too small, need to increase the size of bufferpool.

Operation Steps:

1, check the default IBMDEFAULTBP size;

2, set the IBMDEFAULTBP size to 12800;

3. Restart the DB instance, then execute the complex SQL and discover that there is no problem.

DB2: There are currently no pages available in the buffer pool "1" ... sqlcode=-1218, sqlstate=57011, driver=3.61.75