Group Object Analysis Volume Database Summary Attributes

Use the Group Object Analysis (GOA) Volume Database Summary attributes to create situations that monitor I/O activity for a single volume in a DB2 database.

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

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.

DB2 Read I/O The number of read I/Os. Valid value is an integer in the range 0 - 2147483647; for example, 22.

DB2 Read I/O Rate The read I/O rate per second. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 1.2.

DB2 Read I/O Rate Max The maximum DB2 read I/O rate per second during the current interval. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.4.

DB2 Write I/O The number of write I/Os. Valid value is an integer in the range 0 - 2147483647; for example, 20.

DB2 Write I/O Rate The write I/O rate per second. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 1.0.

DB2 Write I/O Rate Max The maximum write I/O rate per second during the current interval. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 1.2.

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

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 Data Sets The total number of allocated data sets for the DB2 being monitored. Valid value is an integer in the range 0 - 10000.

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

Number of Extents The number of data set extents that the operating system has allocated for a data set. Valid value is an integer in the range 0 - 219.

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.

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.

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

Total DB2 I/O The total DB2 I/O count. Valid value is an integer in the range 0 - 2147483647.

Total DB2 I/O Rate The total I/O rate per second. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.4.

Total DB2 I/O Rate Max The maximum I/O rate per second during the collection interval. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.5.

Volume Name The name of the volume that contains the DB2 objects. It is an alphanumeric text string, to a maximum of 6 characters; for example, PRI123.

Volume Use Percent The percentage of DB2 I/O activity to the volume. The program calculates the value by dividing the total I/O rate for the database by the total I//O rate for the volume. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 100.0; for example, 3.0.