DSNB755I DB2 GROUP BUFFER POOL STATUS CONNECTED = status1 CURRENT DIRECTORY TO DATA RATIO = ratio1 PENDING DIRECTORY TO DATA RATIO = ratio2 CURRENT GBPCACHE ATTRIBUTE = gcache1 PENDING GBPCACHE ATTRIBUTE = gcache2

Message DSNB750I or DSNB751I is followed by a description of the status of the group buffer pool.

DSNB755I - DB2 GROUP BUFFER POOL STATUS               CONNECTED = status1 
             CURRENT DIRECTORY TO DATA RATIO = ratio1
             PENDING DIRECTORY TO DATA RATIO = ratio2
             CURRENT GBPCACHE ATTRIBUTE = gcache1
             PENDING GBPCACHE ATTRIBUTE = gcache2
DSNB756I - CLASS CASTOUT THRESHOLD = class-threshold1,class-threshold2
           GROUP BUFFER POOL CASTOUT THRESHOLD = gbp-threshold % 
           GROUP BUFFER POOL CHECKPOINT INTERVAL = interval MINUTES 
           RECOVERY STATUS = status1 
           AUTOMATIC RECOVERY = auto-recovery

status1

An indication of whether the Db2subsystem on which the DISPLAY GROUPBUFFERPOOL command was issued is connected to the group buffer pool.

YES

The Db2 subsystem is actively connected to the group buffer pool.

NO

The Db2 subsystem is not actively connected to the group buffer pool.

ratio1

The ratio of the number of directory entries to the number of data pages, as specified for the current allocation of the group buffer pool.

ratio2

The requested ratio of directory entries to data pages to take effect at the next reallocation of the group buffer pool.

gcache1

The value of the GBPCACHE attribute for the current allocation of the group buffer pool.

gcache2

The value of the GBPCACHE attribute to take effect at the next reallocation of the group buffer pool.

class-threshold1

The threshold at which class castouts are to be initiated. This value is expressed as a percentage of the group buffer pool size.

class-threshold2

The threshold at which class castouts are to be initiated. This value is expressed as an absolute number of buffers. class-threshold2 is used to determine the threshold only if class-threshold1 is zero and class-threshold2 is nonzero. Otherwise, class-threshold1 is used to determine the threshold.

gbp-threshold

The threshold at which castouts are to be initiated at the group buffer pool level. This value is expressed as a percentage of the group buffer pool size.

interval

The time, in minutes, between successive group buffer pool checkpoints.

status1

The recovery status for the group buffer pool. Possible values are:

DAP

Damage assessment is pending. Db2 is assessing damage to the group buffer pool in response to a coupling facility structure failure. The group buffer pool is temporarily stopped by Db2 and is unavailable for use until Db2 completes the damage assessment.

NORMAL

No pending recovery action exists for this group buffer pool.

auto-recovery

The value of the AUTOREC attribute for the group buffer pool. Possible values are:

YES

If the group buffer pool fails, Db2 is to automatically initiate recovery for the objects that use this group buffer pool. YES is the default.

NO

Db2 is not to initiate automatic group buffer pool recovery. If the group buffer pool fails, issue Db2 START DATABASE commands to recover the objects.

Related information

• -ALTER GROUPBUFFERPOOL command (Db2)
• -START DATABASE command (Db2)
• How Db2 writes from the group buffer pool to disk
• Group buffer pool thresholds