Group Object Activity Summary attributes

Use the Group Object Activity Summary attributes to create situations that monitor the I/O and getpage activity by database.

ASYNC Write Rate The number of asynchronous writes per second during the collection interval. Valid format is a decimal number, with 1 decimal place allowed, in the range 0.0 - 9999.9.

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.

Database The name of a Db2 database. It is an alphanumeric text string with a maximum of 8 characters; for example, DSNDB06.

Db2 ID The name of a Db2 subsystem.

Getpage Percent The percentage of total getpage activity that is applicable to the database, space name, or thread. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 100.0; for example, 2.5.

Getpage Rate The number of getpage requests per second for the database or space name. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.3.

Getpage RIO Ratio The ratio of getpage requests to read I/Os for the database.

The ratio is calculated by dividing the number of getpage requests by the sum of the following values:

Number of synchronous reads
Number of prefetch read I/Os

Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 1.8.

ID Name An internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID. It is an alphanumeric text string 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.

Number of ASYNC Writes The number of asynchronous writes during the collection interval. 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 Getpages The number of getpage reads for the database or space name. Valid value is an integer in the range 0 - 2147483647.

Number of Other Writes The number of immediate and format writes. Valid value is an integer in the range 0 - 2147483647.

Number of Prefetch Reads The number of prefetch read I/Os for the database. Valid value is an integer in the range 0 - 2147483647.

Number of SYNC Reads The number of synchronous reads for the database or space name. 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.

Other Write Rate The number of immediate and format writes per second. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 0.6.

Percent of I/O The percentage of the total I/O activity that is applicable to the database or space name. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 100.0; for example, 2.0.

Prefetch Read Rate The number of prefetch read I/Os per second for the database or space name. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 0.9.

Space Name The name of the selected space for which thread activity has occurred. It is an alphanumeric text string, with a maximum of 8 characters; for example DSNUCX01.

SYNC Read Rate The number of synchronous reads per second for the database or space name. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.2.

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