Use the GOA Thread Activity summary attributes to create situations that monitor thread activity.
ASYNC Write RateThe 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 Identifier The primary authorization ID from connection or signon that identifies the execution privileges an application has to a DB2 object or service. Valid format is alphanumeric with a maximum of 8 characters; for example, TRAN5.
Correlation Identifier he correlation between an application and the connection to a DB2 system. Valid format is alphanumeric, with a maximum of 4 characters; for example D412.
Database The name of a DB2 database. Valid format is alphanumeric with a maximum of 8 characters; for example, DSNDB06.
Data Sharing Group The name of a data sharing group. Valid format is alphanumeric, with a maximum of 8 characters; for example, TDDB241G.
DB2 Identifier The name of a DB2 subsystem.
Dynamic Prefetch Read Rate The number of dynamic prefetch read I/Os made per second by the thread. The dynamic prefetch is not available in DB2 Version 2.3. 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
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, spacename, 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 spacename. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.3.
IDNAMEAn internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID. Valid format is alphanumeric with a maximum of 8 characters; for example TDDB242G.
List Prefetch Read RateThe 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) identifier. Valid format is alphanumeric 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. Dynamic prefetch is not available with DB2 Version 2.3. Valid value is an integer in the range 0 - 2147483647.
Number of Getpage ReadsThe number of getpage reads for the database or spacename. Valid value is an integer in the range 0 - 2147483647.
Number of List Prefetch Reads The number of list prefetch 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 Seq 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 spacename. Valid value is an integer in the range 0 - 2147483647.
Number of Threads The total number of currently monitored threads. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9.
Originating System Identifier Identifies the originating Candle Management Server (CMS). Valid format is alphanumeric, with a maximum of 32 characters; for example, DB2.USCACO01.D412.
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 spacename. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 100.0; for example, 2.0.
Planname The name of an application plan that DB2 produces during the bind process and uses for processing SQL statements during execution. Valid format is alphanumeric, 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.
Seq 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.2.
Spacename The name of the selected space for which thread activity has occurred. Valid format is alphanumeric, with a maximum of 8 characters; for example DSNUCX01.
SYNC Read Rate The number of synchronous reads per second for the database or spacename. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.2.
Timestamp
Represents the end of data collection or the end of an interval, and is
the local time where the system is running. Valid format is
MM-DD-YY HH:MM:SS, where:
MM |
Month |
DD |
Day |
YY |
Year |
HH |
Hour |
MM |
Minute |
SS |
Second |
For example, 07-16-00 14:58:29 indicates that data collection ended on July 16, 2000 at 14:58:29 PM.
Questions or comments? Let us know at userdoc@candle.com
Copyright © 1996--2002 Candle Corporation. All rights reserved. International
rights secured.