Use the DB2 Thread Exceptions attributes to create situations to monitor thread-related performance.
Archive Tape Wait True if waiting for a tape for an archive operation. Valid entry is an alphanumeric text string, with a maximum length of one character.
Authorization Identifier Authid of the thread. Valid entry is an alphanumeric text string, with a maximum length of eight characters.
Cancel Command Command string needed to cancel a thread. Valid entry is an alphanumeric text string, with a maximum length of eight characters.
Commit Count Number of commits by this thread during the last interval. Valid entry is an integer of up to four digits.
Commit Ratio Ratio of total system page updates to total commits. Valid entry is an integer of up to four digits.
Connection Identifier The connection identifier for this thread. Valid entry is an alphanumeric text string, with a maximum length of eight characters.
Connection Type The type of connection associated with the thread. Valid entry is an integer of up to four digits.
Correlation Identifier The correlation identifier for this thread. Valid entry is an alphanumeric text string, with a maximum length of 12 characters.
CPU Utilization Rate of CPU consumption during last interval. Valid entry is an integer of up to four digits.
DB2 CPU Used Total DB2 CPU time used for this thread. Valid entry is an integer of up to four digits, in units that represent milliseconds.
DB2 Elapsed Time Elapsed time DB2 has been processing thread. Valid entry is an integer of up to four digits, in units that represent tenths of seconds.
DB2ID The name of the DB2 system on which this thread is running. Valid entry is an alphanumeric text string, with a maximum length of four characters.
Distributed CPU Seconds Amount of CPU time being used by a distributed DB access thread. Valid entry is an integer of up to four digits, in units that represent milliseconds.
Distributed Receive Bytes Amount of data received by distributed threads from remote DB2. Valid entry is an integer of up to four digits.
Distributed Send Bytes Amount of data sent by distributed threads to remote DB2. Valid entry is an integer of up to four digits.
Elapsed Time Elapsed time for a DB2 thread. Valid entry is an integer of up to four digits, in units that represent seconds.
Getpage Count Number of get page operations for this thread during the last interval. Valid entry is an integer of up to four digits.
Getpage Ratio Number of Get pages divided by the Read I/O count. Valid entry is an integer of up to four digits.
Indoubt If True, the thread is in an Indoubt status. Valid entry is an alphanumeric text string, with a maximum length of one character.
Interval Time The amount of time this thread has existed during the last sampling period. Valid entry is an integer of up to four digits, in units that represent seconds.
Lock Percentage Number of locks owned divided by the maximum allowed locks for a thread. Valid entry is an integer of up to four digits.
Locks Max Maximum number of locks allowed for a single thread. Valid entry is an integer of up to four digits.
Locks Owned Number of locks this thread currently owns. Valid entry is an integer of up to four digits.
Misc Flag Miscellaneous flag. Valid entry is an alphanumeric text string, with a maximum length of one character.
MVS System The name of the MVS image where the DB2 system identified by the DB2ID field is running. Valid entry is an alphanumeric text string, with a maximum length of four characters.
Name DB2 thread name. Valid entry is an alphanumeric text string, with a maximum length of four characters.
Originnode Node name of the DB2 system. Valid entry is an alphanumeric text string, with a maximum length of 32 characters.
Page Update Rate Number of page update requests per second made by a thread. Valid entry is an integer of up to four digits.
Plan Name The identifier of the plan this thread is executing. Valid entry is an alphanumeric text string, with a maximum length of eight characters.
Prefetch Count Number of sequential, prefetch operations during the interval. Valid entry is an integer of up to four digits.
Prefetch Rate Read sequential, prefetch rate. Valid entry is an integer of up to four digits.
Read Count Number of read operations during the interval. Valid entry is an integer of up to four digits.
Read I/O Rate Thread synchronous read I/O rate. Valid entry is an integer of up to four digits.
Resource Count Total resource count. Valid entry is an integer of up to four digits.
Resource Limit Limit on number of resources allowed. Valid entry is an integer of up to four digits.
Resource Limit Percent Resource usage divided by resource limit. Valid entry is an integer of up to four digits.
Sync Read Count Number of synchronous reads during last interval. Valid entry is an integer of up to four digits.
Thread Create Wait Application waiting for thread creation. Valid entry is an alphanumeric text string, with a maximum length of one character.
Thread Status Description of the current thread status. Valid entry is an alphanumeric text string, with a maximum length of 12 characters.
Thread Token Thread token used as foreign key to DDF, also used for the cancel thread command. Valid entry is an integer of up to four digits.
Thread Type Thread type. Valid entry is an integer of up to four digits.
Time The date and time, as set on the monitored system, indicating the instance when the agent collects information. The timestamp format for SCAN and STR functions is CYYMMDDHHMMSSmmm (as in 1020315064501000 for 03/15/02 06:45:01) where:
C = Century (0 for 20th, 1 for 21st)
Y = Year
M = Month
D = Day
H = Hour
M = Minute
S = Second
m = millisecond
Update Count Number of update operations during last interval. Valid entry is an integer of up to four digits.
Wait Resource Resource being waited on. Valid entry is an alphanumeric text string, with a maximum length of six characters.
Wait Time Distributed Query Time distributed allied thread has been waiting for response - remote SQL. Valid entry is an integer of up to four digits, in units that represent milliseconds.
Wait Time Drain Claims Time thread waiting for drain of claims. Valid entry is an integer of up to four digits.
Wait Time Drain Lock Time thread waiting for acquisition of drain lock. Valid entry is an integer of up to four digits.
Wait Time Global Lock Time thread waiting because of global contention. Valid entry is an integer of up to four digits.
Wait Time Log Queue Time thread waiting for ARCHIVE LOG MODE(QUIESCE). Valid entry is an integer of up to four digits.
Wait Time Procedure Time thread waiting for a TCB to schedule a stored procedure. Valid entry is an integer of up to four digits.
Wait Time Resource Time thread waiting for a resource. Valid entry is an integer of up to four digits.
Wait Time Service Time thread waiting for DB2 Service. Valid entry is an integer of up to four digits, in units that represent milliseconds.
Questions or comments? Let us know at userdoc@candle.com.
Copyright © 2004 Candle Corporation. All rights reserved. International
rights secured.