00C20205   

Explanation

DB2® is unable to access a group buffer pool because of a damage assessment pending (DAP) status against the group buffer pool.

System action

The action DB2 takes depends on the situation, as follows:
  • If DB2 tries to read a page from the group buffer pool and finds that the group buffer pool is in DAP status, the following actions are taken:
    • SQLCODE -904 (resource not available) is returned to the user with this reason code. The name of the group buffer pool is also returned.
  • If DB2 tries to read a page from the group buffer pool for rollback, backout, or restart and finds that the group buffer pool is in DAP status, the following actions are taken:
    • The page is added to the logical page list (LPL) for the page set.
    • Message DSNB250E is issued to the console with this reason code.
  • If DB2 tries to write a page to the group buffer pool and finds that the group buffer pool is in DAP status, the following actions are taken:
    • The page is added to the logical page list (LPL) for the page set.
    • Message DSNB250E is issued to the console with this reason code.
  • If DB2 detects DAP status when it tries to connect the group buffer pool, or if DB2 detects a group buffer pool version ID mismatch after a successful connection, the following actions are taken:
    • The damage assessment process is triggered for this group buffer pool.
    • SQLCODE -904 (resource not available) is returned to the user with this reason code. The name of the group buffer pool is also returned.
    • Unless already issued, message DSNB301E, which contains this reason code, is issued to the console.

System programmer response

Message DSNB304I is issued when the group buffer pool is entered into DAP state and message DSNB305I is issued when the DAP status is cleared. During the damage assessment process, DB2 must determine which page sets or partitions might have had changed pages in the failed coupling facility structure and need to be recovered. Each page set/partition fitting this criteria is entered into 'group buffer pool REBUILD pending (GRECP)' status. A page set/partition in GRECP status remains unavailable for read or update until it is recovered.

User response

Contact the system programmer.