Problem: allocation failure of the group buffer pool

Symptom

DSNB301E -DB1A csect-name GROUP BUFFER POOL
gbpname CANNOT BE CONNECTED
DB2 REASON CODE =  reason1
MVS IXLCONN REASON CODE =  xxxx0C08

System action

Applications needing access to group buffer pool data are rejected with a -904 SQL return code (reason code 00C20204).

If the group buffer pool cannot be allocated in an alternate coupling facility as specified on the preference list of the CFRM policy, no inter-Db2 RW activity can exist on the table spaces, indexes, or partitions that are assigned to this buffer pool. If the group buffer pool that cannot be allocated is group buffer pool 0, no update activity can exist on the Db2 catalog and directory.

System programmer action

Use IFCID 0250 in performance class 20 to determine the reason for the allocation failure. If the trace indicates that the reason for the allocation failure is inadequate storage in the coupling facility, you can:

• Change the CFRM policy to decrease the amount of storage for the group buffer pool, or redefine that group buffer pool to a different coupling facility that has more storage.
• Have the database administrator reassign some of the table spaces or indexes that are using that group buffer pool to a different group buffer pool.