DSNB603I   INSUFFICIENT STORAGE TO CREATE/EXPAND BUFFER POOL bpname TO SPECIFIED SIZE integer. BUFFER POOL SIZE IS NOW integer.

Explanation

A buffer pool could not be created or expanded to the requested size. Insufficient storage exists within the ssnmDBM1 address space to build the buffer pool. The buffer pool size is set by the ALTER BUFFERPOOL command and can be queried by using the DISPLAY BUFFERPOOL command.

System action

The buffer pool is created or expanded to the size allowed by the available storage. If the buffer pool cannot be created at all, and the creation request was triggered by a page set open by an application, then an SQLCODE -904 (resource not available) is returned to the user. Reason code 00C200E8 and the buffer pool external name are recorded in the cursor table (CT), which is available in the SQL communication area (SQLCA) or messages.

Operator response

Notify the system programmer.

System programmer response

Analyze the storage content of the ssnmDBM1 address space to determine further action. If appropriate, use the ALTER TABLESPACE or ALTER INDEX statement to use a different buffer pool. Otherwise, use ALTER BUFFERPOOL commands to balance storage use for all buffer pools.