Thread Statistics Attributes
Use Thread Statistics attributes to create situations that determine the usage of parallel threads.
Asynchronous Page Reads The number of asynchronous page reads for prefetch. Valid value is an integer in the range 0 - 2147483647.
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.
Dynamic Prefetch The number of dynamic prefetch requests. Valid value is an integer in the range 0 - 2147483647.
Get Page Requests The number of thread getpage requests. This includes conditional, unconditional, successful, and unsuccessful requests. Valid value is an integer in the range 0 - 2147483647.
IDNAME An internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID.
Immediate Write I/O The number of synchronous write I/O requests that DB2 issues on behalf of a thread. Valid value is an integer in the range 0 - 2147483647.
List Prefetch The number of list prefetch requests that a thread issues. Valid value is an integer in the range 0 - 2147483647.
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 SETW The number of set write requests to write a page out to DASD. 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.
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 The number of sequential prefetch requests that a thread issues. Valid value is an integer in the range 0 - 2147483647.
Synchronous Read I/O The number of synchronous read I/O requests that a thread issues. Valid value is an integer in the range 0 - 2147483647.
Time Stamp Represents the end of data collection or the end of an interval, and is the local time where the system is running.
Type Indicator Indicates the type of parallel thread.
| Value | Description |
|---|---|
| blank | Not a parallel thread |
| Parent | Parallel thread is a parent |
| Child | Parallel thread is a child |
| Autonomous SP | Originating thread who invoked autonomous stored procedures |
Unsuccessful Get Page Operation The number of conditional getpage requests that failed. Valid value is an integer in the range 0 - 2147483647.