DSNB605I   UNABLE TO CREATE BUFFER POOL bpname TO SPECIFIED SIZE DURING STARTUP/RESTART. INSUFFICIENT VIRTUAL STORAGE

Explanation

An attempt to create the buffer pool failed at the time that DB2® was performing its startup or restart processing. Insufficient virtual storage exists within the ssnmDBM1 address space for building the buffer pool. The name of the buffer pool is bpname.

System action

The buffer pool is not created. The table space or index open request, which triggered the attempt to create the buffer pool, fails. 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.

This message is non-scrollable. It remains highlighted on the console until you take the appropriate action.

Operator response

Notify the system programmer. This message remains on the console until the operator deletes it.

System programmer response

Analyze the virtual storage content of the DSNDBM1 ssnmDBM1 address space to determine further action. If appropriate, use ALTER BUFFERPOOL commands to balance virtual storage use for all buffer pools.