Local Group Object Analysis Thread Activity Attributes

Use the Local Group Object Analysis (GOA) Thread Activity attributes to create situations that monitor thread activity.

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.

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.

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.

Dynamic Prefetch Read Rate The number of dynamic prefetch read I/Os made per second by the thread. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.2.

Getpage per Read I/O 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.

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.

IDNAME An internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID. VIt is an alphanumeric text string with a maximum of 8 characters; for example TDDB242G.

List Prefetch Read Rate The number of list prefetch read I/Os made per second by the thread. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.5.

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 Dynamic Prefetch Reads The number of dynamic prefetch read I/Os made by the thread. Valid value is an integer in the range 0 - 2147483647.

Number of Getpage Reads The number of getpage reads for the database or space name. Valid value is an integer in the range 0 - 2147483647.

Number of List Prefetch Reads The number of list prefetch read I/Os made by the thread. 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 Sequential Prefetch Reads The number of sequential prefetch reads for the thread. 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 format 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 format is a decimal number, with one decimal place allowed, in the range 0.0 - 100.0; for example, 2.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.

Sequential Prefetch Read Rate The number of sequential prefetch read I/Os per second made by the thread. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.1.

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