Group Buffer Pool Statistics attributes

Use Group Buffer Pool (GBP) Statistics attributes to create situations that monitor the utilization of critical group buffer pool resources.

Castout Engine Not Available The number of times a castout engine was not available to write changed pages from a group buffer pool to DASD. Valid value is an integer in the range 0 - 2147483647.

Castout for Class Threshold The group buffer pool castout class threshold. Castout begins when the number of changed pages for a particular castout class exceeds this threshold. Valid value is an integer in the range 0 - 2147483647.

Castout for GBP Threshold The group buffer pool castout threshold. Castout begins when the number of changed pages in the group buffer pool exceeds this threshold. Valid value is an integer in the range 0 - 2147483647.

Changed Page Writes The number of changed pages written to the group buffer pool. Valid value is an integer in the range 0 - 2147483647.

Clean Page Writes The number of clean pages written to the group buffer pool. Valid value is an integer in the range 0 - 2147483647.

Cross Invalidate Reads No Data The number of reads to the group buffer pool because a page in the member's buffer pool was invalidated, where the data was not found in the group buffer pool and the member read the page from DASD. Valid value is an integer in the range 0 - 2147483647.

Cross Invalidate Reads With Data The number of reads to the group buffer pool because a page in the member's buffer pool was invalidated, where the data was found and returned to the member. Valid value is an integer in the range 0 - 2147483647.

Data Sharing Group The name of a data sharing group. It is an alphanumeric text string, with a maximum of 8 characters; for example, TDDB241G.

Db2 ID The name of a Db2 subsystem.

IDNAME An internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID.

GBP Reads No Data The number of reads to the group buffer pool where the data was not found. Valid value is an integer in the range 0 - 2147483647.

GBP Reads With Data The number of reads to the group buffer pool where the data was found. Valid value is an integer in the range 0 - 2147483647.

IXLCACHE Delete Name The number of times that Db2 issued a request to the group buffer pool to delete directory and data entries associated with a specific page set or partition. Valid value is an integer in the range 0 - 2147483647.

IXLCACHE Read Castout Class The number of requests from the pageset or partition castout owner or the group buffer pool owner to the group buffer pool to determine which pages are cached in the group buffer pool as changed pages that need to be cast out. Valid value is an integer in the range 0 - 2147483647.

IXLCACHE Read Castout Stats The number of requests that the group buffer pool structure owner issues when the GBPOOLT threshold is reached to determine which castout classes have changed pages. Valid value is an integer in the range 0 - 2147483647.

IXLCACHE Read Directory Information The number of requests that the group buffer pool structure owner issues for group buffer pool checkpoints to read the directory entries of all changed pages in the group buffer pool. Valid value is an integer in the range 0 - 2147483647.

IXLCACHE Read STGSTATS The number of times Db2 requested statistical information from the group buffer pool. Valid value is an integer in the range 0 - 2147483647.

IXLCACHE Unlock Castout The number of times that Db2 issues an unlock request to the coupling facility for castout I/Os that have completed. Valid value is an integer in the range 0 - 2147483647.

MVS System The MVS System Management Facility (SMF) ID. It is an alphanumeric text string with a maximum of 4 characters; for example SP11.

Number of Checkpoints The number of times that Db2 writes the changed pages in the group buffer pool to the pageset. Valid value is an integer in the range 0 - 2147483647.

Number of Db2 systems The total number of monitored Db2 systems. Valid value is an integer in the range 1 - 64.

Number of Pages Castout The number of data pages that a member has cast out of the group buffer pool to DASD. Valid value is an integer in the range 0 - 2147483647.

Number of Rebuilds The number of times that a member has participated in rebuilding a group buffer pool. Valid value is an integer in the range 0 - 2147483647.

Originating System ID The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.

Prefetch Read No Data The number of reads to the group buffer pool for prefetch processing, where the data is not found and the member reads the page from DASD. Valid value is an integer in the range 0 - 2147483647.

Prefetch Read With Data The number of reads to the group buffer pool for prefetch processing, where the data is found and returned to the member. Valid value is an integer in the range 0 - 2147483647.

Read Fails for Storage The number of group buffer pool read requests that failed because of a shortage of coupling facility resources. Valid value is an integer in the range 0 - 2147483647.

Register Page List Request The number of register page list requests by prefetch. Valid value is an integer in the range 0 - 2147483647.

Register Page Request The number of times that Db2 requested interest to the group buffer pool for a single page. Valid value is an integer in the range 0 - 2147483647.

RPL Reads Changed Pages The number of group buffer pool reads by prefetch to retrieve a changed page from the group buffer pool as a result of feedback from the register page list. Valid value is an integer in the range 0 - 2147483647.

RPL Reads Clean Pages The number of group buffer pool reads by prefetch to retrieve a clean page from the group buffer pool as a result of feedback from the register page list. Valid value is an integer in the range 0 - 2147483647.

Structure Name The name of a Db2 coupling facility structure. It is an alphanumeric text string, with a maximum of 16 characters; for example, TDDB241G.SCA.

Time Stamp Represents the end of data collection or the end of an interval, and is the local time where the system is running.

For example, 07-16-12 14:58:29 indicates that data collection ended on July 16, 2012 at 14:58:29 PM.

Unregister Page Request The number of times that Db2 unregistered interest for a single page from the group buffer pool. Valid value is an integer in the range 0 - 2147483647.

Write Engine Not Available The number of times a write engine was not available to perform a coupling facility write. Valid value is an integer in the range 0 - 2147483647.

Write Fails for Storage The number of group buffer pool write requests that failed because of a shortage of coupling facility resources. Valid value is an integer in the range 0 - 2147483647.

Write System Changed Page The number of changed pages written to the group buffer pool. Valid value is an integer in the range 0 - 2147483647.

Write System Clean Page The number of clean pages written to the group buffer pool. Valid value is an integer in the range 0 - 2147483647.