Group Object Analysis Thread Volume Summary attributes

Use the Group Object Analysis (GOA) Thread Volume Summary attributes to create situations that monitor the thread activity for volumes.

Authorization ID The primary authorization ID from connection or sign-on that identifies the execution privileges an application has to a Db2 object or service. It is an alphanumeric text string with a maximum of 8 characters; for example, TRAN5.

Correlation ID The correlation between an application and the connection to a Db2 system. It is an alphanumeric text string, with a maximum of 4 characters; for example D412.

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 Write I/O The number of I/O writes. 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.2.

IDNAME 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.

Max Db2 I/O Rate The maximum Db2 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.2.

Max Db2 Read I/O Rate 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.

Max Db2 Write I/O Rate 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.0.

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 Threads The total number of currently monitored threads. Valid value is an integer in the range 0 - 999999.

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.

Percent Volume Use 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.

Plan Name The name of an application plan that Db2 produces during the bind process and uses for processing SQL statements during execution. It is an alphanumeric text string, with a maximum of 8 characters. For example, PLANLCK2 is the name of an application plan. *SYSTEM* indicates Db2 subsystem-generated threads that own or are waiting on a lock.

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.

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.