Group Buffer Pool attributes
Use Group Buffer Pool (GBP) attributes to create situations to determine the usage and availability of coupling facility structures relating to group buffer pools, the shared communication area, and the lock table.
Cross Invalidate Count The number of notifications that the Db2 buffer has modified. Valid value is an integer in the range 0 - 99999999.
Cross Invalidate Rate The rate of cross invalidations per second. Valid value is an integer in the range 0 - 99999999.
Data Pages The number of data pages that Db2 has allocated for the group buffer pool. Valid value is an integer in the range 0 - 99999999.
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.
Directory Entries The total number of directory entries that a Db2 system has allocated for a coupling facility structure. Valid value is an integer in the range 0 - 99999999.
IDNAME An internal attribute used for navigation. It contains either the Data Sharing Group Name or the DB2ID.
Valid format is alphanumeric with a maximum of 8 characters; for example TDDB242G.
MVS System The MVS System Management Facility (SMF) ID. It is an alphanumeric text string with a maximum of 4 characters; for example SP11.
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.
Read Count The total number of page read requests to a group buffer pool. Valid value is an integer in the range 0 - 99999999.
Read Hit Count The number of successful page read requests to a group buffer pool without causing a physical database read. Valid value is an integer in the range 0 - 99999999.
Read Hit Percent The percentage of successful page read requests in relation to the total page read requests for a group buffer pool. Valid value is an integer in the range 0 - 100.
Structure Connect Count The number of active connections to a structure. Valid value is an integer in the range 0 - 16.
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.
Structure Size The size, in kilobytes, of a Db2 coupling facility structure. Valid value is an integer in the range 0 - 99999999.
Structure Status The current status of the coupling facility structure.
| Value | Description |
|---|---|
| ACTIVE | The structure is active |
| INACTIVE | The structure is inactive |
| Value | Description |
|---|---|
| REB_NEW | Rebuild on new (secondary GBP) |
| REB_OLD | Rebuild on old (primary) GBP |
| REB_TRAN | Structure is in transition |
| REB_HOLD | Structure is in holding state |
| REB_ERR | Error during the structure rebuild |
Structure Type The type of Db2 coupling facility structure.
| Value | Description |
|---|---|
| CACHE | Cache data of interest to several Db2 systems in data sharing group |
| LIST | Shared Communications Area (SCA) for data sharing group members |
| LOCK | Controls locking |
Time Stamp Represents the end of data collection or the end of an interval, and is the local time where the system is running.