DSNB601I   BUFFER POOL bpname FULL

Explanation

A buffer is required to access a database page that is not currently contained within the buffer pool. A buffer cannot be assigned because all buffers in the buffer pool are in a nondisplaceable state. (Buffers are in a nondisplaceable state when they contain actively referenced pages or updated pages for which writes are pending.)

This message can occur if there is an overload of concurrent activity for the buffer pool size. The variable bpname is the buffer pool external name.

System action

Reason code 00C200E9 and the buffer pool external name are recorded in the cursor table (CT), which is available in the SQL communication area (SQLCA) or messages. An SQLCODE -904 (resource not available) is returned to the user.

Operator response

Notify the system programmer.

System programmer response

Do one of the following:
  • Reduce concurrent activity by reducing the number of DB2® threads.
  • Use the ALTER BUFFERPOOL command to increase the size of the buffer pool.