DB2 Group Coupling Facility Attributes
Use the DB2 Group Coupling Facility attributes to create situations that determine the excess usage and reduced availability of group coupling facility structures.
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 Change Requests The number of change requests for P-locks. Valid value is an integer in the range 0 - 99999999.
DB2 False Contention Provides a global view of false contentions for all DB2 systems in a data sharing group. The formula is the number of false contentions divided by the total number of global contentions, multiplied by 100. Valid value is an integer in the range 0 - 99999999.
DB2 False Suspends The number of suspends because of MVS XES (Cross-system Extended Services) false contention. Valid value is an integer in the range 0 - 99999999.
DB2 Global Contention Provides a global view of global contentions for all DB2 systems in a data sharing group. The formula is the total number of suspends because global contention divided by the total number of XES requests, multiplied by 100. Valid value is an integer in the range 0 - 99999999.
DB2 IRLM Suspends The number of suspends because of IRLM global resource contentions. This occurs when IRLM states are in conflict and require inter-system communication for resolution. Valid value is an integer in the range 0 - 99999999.
DB2 Lock Requests The number of lock requests for P-locks. Valid value is an integer in the range 0 - 99999999.
DB2 Unlock Requests The number of unlock requests for P-locks. Valid value is an integer in the range 0 - 99999999.
DB2 XES Suspends The number of suspends because MVS XES global resource contentions that are not IRLM-level contention. This occurs when XES lock states are in conflict but the IRLM lock states are not in conflict. Valid value is an integer in the range 0 - 99999999.
False Contention The number of contentions that the IRLM thought were competing for the same database resource. Valid value is an integer in the range 0 - 99999999.
Usage: An IRLM subsystem identifies a contention but grants a lock to a contending IRLM subsystem because the contending IRLM is requesting access to a different segment in the database.
False Contention Rate The number of false contentions divided by the number of seconds during the collection interval. Valid value is an integer in the range 0 - 99999999.
Global Contention The total number of contentions competing for the same database resource. Valid value is an integer in the range 0 - 99999999.
Global Contention Rate The number of contentions divided by the number of seconds during the collection interval. 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.
List Entries Allocated The total number of list entries that a DB2 system has allocated for the LOCK1 coupling facility structure. Valid value is an integer in the range 0 - 99999999.
List Entries Percent The number of list entries that IRLM is currently using divided by the number of list entries that DB2 has allocated. Valid value is an integer in the range 0 - 100.
List Entries Used The total number of list entries IRLM is currently using for the LOCK1 coupling facility structure. Valid value is an integer in the range 0 - 99999999.
Lock Entries Allocated The total number of lock entries that a DB2 system has allocated for the LOCK1 coupling facility structure. Valid value is an integer in the range 0 - 99999999.
Lock Entries Percent The number of lock entries that IRLM is currently using divided by the number of lock entries DB2 has allocated. Valid value is an integer in the range 0 - 100.
Lock Entries Used The total number of lock entries IRLM is currently using for the LOCK1 coupling facility structure. Valid value is an integer in the range 0 - 99999999.
Number of Indexes Identifies the number of indexes.
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.
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 |
Structure Used The number of kilobytes that DB2 uses within a structure type. Valid value is an integer in the range 0 - 99999999.
Structure Used Percent The percent of the total available kilobytes that DB2 is currently using within a structure type. Valid value is an integer in the range 0 - 100.
Time Stamp Represents the end of data collection or the end of an interval, and is the local time where the system is running.