Error SQLCODE: -1218

[Franco Lombardo]

I'm running a DB2 9.5 Express C on Windows XP.
Sometimes, when using JDBC to connect to this box, I receive the message:

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1218, SQLSTATE:
57011

SQL1218N There are no pages currently available in bufferpool 1

Any hints?

Thanks.

Bye.

Franco

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.francolombardo.net
Scala, Java, As400.....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[Ian]

Franco Lombardo wrote:
> I'm running a DB2 9.5 Express C on Windows XP.
> Sometimes, when using JDBC to connect to this box, I receive the message:
>
> com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1218, SQLSTATE:
> 57011
>
> SQL1218N There are no pages currently available in bufferpool 1
>
> Any hints?
>

Your bufferpool is undersized for the work that you are trying to do.

All pages in your bufferpool are dirty, and there are active
transaction(s) that preclude the page cleaners from writing out the
dirty pages.

Typically, this only occurs on VERY small bufferpools -- maybe 100
pages or less, combined with a (relatively) large unit of work.

Increase the size of your bufferpool and you should solve the
problem...