Thread History

Use these attributes to view Db2 thread history.

ACCEL Elig CPU The accumulated CPU time that Db2 spent processing SQL that might be eligible for execution on an accelerator (Field name: QWAC_ACCEL_ELIG_CP).

ACCEL Elig ETime The accumulated elapsed time that Db2 spent processing SQL that might be eligible for execution on an accelerator (Field name: QWAC_ACCEL_ELIG_ELA).

ACCEL Elig SE CPU The accumulated CPU time Db2 spent processing SQL on an IBM specialty engine, when that SQL was eligible for processing on an accelerator (Field name: QWAC_ACCEL_ELIG_SE).

ACE Address Agent control element (ACE) of the thread that was used when this record was written. An ACE is an identifier that is unique to a given thread for the life of the thread. Using the ACE values, it is possible to separate out trace records from concurrent unrelated threads. When a thread is terminated, the ACE value is freed and can be used later by a subsequent thread. There are times when an ACE value in the data indicates that the function performed under the ACE in NTHACE is actually being performed on behalf of another ACE, as indicated by the ACE value in the data section. An example of this is when a sequential prefetch read is done by a Db2 service task on behalf of a thread. (Field name: NTHACE).

Authorization ID Initial primary authorization ID. (Field name: NTHAUTH).

Connection ID Connection name: not valid on end of memory and reflects the z/OS home ASID connection name. (Field name: NTHCONN).

Correlation ID Correlation ID value. (Field name: NTHCORR).

For batch: JOBNAME.
For TSO: LOGON-ID.
For IMS/VS: PST#.PSBNAME.
For CICS: CONNECTION_TYPE.THREAD_TYPE.THREAD_#.TRAN-ID.
For RRSAF: CORRELATION-ID value from SIGNON function.
For threads from a Db2 requester, this field contains the CORRELATION-ID name of the thread at the requesting location.
For threads using the DRDA protocol from a non-Db2 requester, this field contains the first 12 characters in the DDM external name (EXTNAM) parameter of the DDM EXCSAT command received as part of the SQL connect.

Curr WF Blks The current amount of work file space, in KB, that is being used by this agent for traditional workfile use, declared temporary tables, and indexes on declared temporary tables (field name: QWAC_WORKFILE_CURR).

DASD Cache Hit Events The number of synchronous read I/O operations that did not use zHyperlink processing and resulted in disk cache hits.

DASD Cache Hit READS The wait time for synchronous read I/O operations that did not use zHyperlink processing and resulted in disk cache hits.

Data Sharing Group The Data Sharing Group name. (Field name: GROUP).

Database ID Database ID. (Field name: QLLLPIDB).

DB2 Subsystem The Db2 subsystem ID. (Field name: DB2ID).

DB2 Version The Db2 version. (Field name: DB2VER).

DBID DBID for I/O. (Field name: QLLLDB).

Function Code Function code. (Field name: QLLLFC).

Interval Start The start time of this interval. (Field name: TIMESTAMP).

Latch Class Latch class. (Field name: QLLLLC).

Latch Token Latch token. (Field name: QLLLLA).

LOB Wait Events The number of wait trace events that were processed for LOB compression (Field name: QWAX_LOBCOMP_COUNT).

LOB Wait Time The accumulated wait time for LOB compression (Field name: QWAX_LOBCOMP_WAIT).

Lock Latch Begin Time Begin time for the longest lock/latch waits. (Field name: QLLLRBT).

Lock Latch Delta Time Delta time for longest lock/latch waits. (Field name: QLLLRDT).

Lock Latch End Time End time for longest lock/latch waits. (Field name: QLLLRET).

Lock Resource Lock name. (Field name: QLLLLK).

LUWID Logical unit of work ID (LUWID) as defined for the LU 6.2 interface. The LUWID uniquely identifies the thread within the network, and consists of the following:

a fully qualified network name (QWHSLUNM).
an LUW instance number (QWHSLUUV).
an LUW sequence number (see fields below).

The fully qualified network name is a maximum 16-bytes in length, consisting of two 8-character fields, QWHSNID and QWHSLUNM, that together uniquely identify a client system. The LUWID remains the same on IMS, CICS, and RRSAF thread reuse. Second part of network name (see QWHSLWID). Instance number. displayed as 12 hex characters. when concatenated with the fully qualified network name, it uniquely identifies a distributed thread. (though this field may appear to be a timestamp, it is not to be processed as one. For more information see the -display thread command in command reference. LUW sequence number. This identifies the last commit scope in which the logical unit participated. This number is incremented whenever a thread commits or is rolled back. Thread reuse. (Field name: NTHLUW).

Max WF Blks The maximum amount of work file space, in KB, that is being used by this agent at any point in time for traditional work file use, declared temporary tables, and indexes on declared temporary tables (Field name: QWAC_WORKFILE_MAX).

Member Name The Data Sharing Group member name. (Field name: MEMBER).

MVS System The MVS identifier. (Field name: MVSID).

OBID OBID for I/O. (Field name: QLLLOB).

Originating System The managed system name of the agent. Valid format is alphanumeric, with a maximum of 32 characters; example, DB91:SYS1:DB2. (Field name: ORIGINNODE).

Page Latch Begin Time Page latch wait begin time. (Field name: QLLLPIBT).

Page Latch Delta Time Page latch wait delta time. (Field name: QLLLPIDT).

Page Latch End Time Page latch wait end time. (Field name: QLLLPIET).

Page Latch Wait ACE Ace that incurred a longest wait described in part 3 of DSNDQLLL. (Field name: QLLLPIACE).

Page Number Page number. (Field name: QLLLPG).

Pageset ID Pageset ID. (Field name: QLLLPISB).

Partition Number Partition number. (Field name: QLLLPA).

Pipe Wait Events The number of wait trace events that were processed for pipe wait (Field name: QWAX_PIPEWAIT_COUNT).

Pipe Wait Time The accumulated wait time for pipe wait (Field name: QWAX_PIPE_WAIT).

Plan Name Plan name. (Field name: NTHPLAN).

Blank for Db2 command thread; otherwise:

For SPUFI with cursor stability: 'DSNESPCS'.
For SPUFI with repeatable read: 'DSNESPRR'.
For TSO: application plan name.
For IMS: application plan name. IMS and CICS commands have a blank plan name.
For CICS: application plan name. IMS and CICS commands have a blank plan name.
For RRSAF create thread with the collection parameter:'?RRSAF'.
For QMF: 'DSQPLAN'.

For distributed database access threads:

For threads using the DRDA protocol from a requester, this field contains the plan name being executed at the requesting location.
For threads using the DRDA protocol from a non-Db2 requester or from a Db2 2.3 requester, this field contains the constant 'DISTSERV'.
For binding: 'DSNBIND' (system plan).
For UTILITY: 'DSNUTIL ' (system plan).
For AUTHORIZATION: 'ACT' + X'0000000000' (system plan).
For unallocated threads and miscellaneous Db2 system service tasks: 'BCT' + X'0000000000' (system plan).
For startup: 'STARTCT' + X'00' (system plan).

For batch: 'BATCH'.
For TSO: 'TSO'.
For QMF: 'DB2CALL'.
For UTILITY: 'UTILITY'.
For Db2 INTERNAL: Db2 subsystem ID.
For IMS: IMS-ID.
For CICS: CICS-ID.
For RRSAF: 'RRSAF'.

For distributed database access threads:

For threads from a Db2 requester, this field contains the connection name of the thread at the requesting location.
For threads using the DRDA protocol from a non-Db2 requester, this field contains the constant 'SERVER'.

For TSO: LOGON-ID.
For batch: USER-ID on job statement.
For RRSAF if the following conditions are true:
- The system authorization facility (SAF) and a security product, such as RACF, is used
- There is an ACEE associated with the job step TCB or with the ASXB
- The first 7 characters of the job step user ID match the first 7 characters of the value in ACEEUSRI. RRSAF uses the value in ACEEUSRI as the initial primary authorization ID.
If any of the above conditions are not true, then the initial primary authorization ID is the value in ASXBUSER.
For IMS (message-driven regions): SIGNON-ID, LTERM, ASXBUSR, or PSB NAME.
For IMS (control regions): USER-ID on job statement, or RACF, started procedure entry if RACF is used.
For CICS: USERID, OPID, GROUP, SIGN, or TERM, or TX, as specified in the DB2ENTRY resource definition.
For z/OS operator commands and Db2 system internal agents: = 'SYSOPR'.
For a distributed application server (AS):
- If the application requester (AR) is a Db2 system, this is the same value that was assigned at the AR.
- If the application requester is not a Db2 system, this is the user ID that was used to make the initial connection with the application server. The User ID is obtained in one of the following ways:
  - passed by the requester in the allocate conversation flow (FMH5)
  - passed by the requester in the DRDA security flow
  - derived by the server from the RACF passticket
  - provided by the requester in the DRDA security flow

Profile ID This value is the same as the PROFILEID column value in the SYSADM.DSN_PROFILE_TABLE table (field name: QWAC_PROFMON_PID).

Profile Type Profile monitoring type (Field name: QWAC_PROFMON_TYPE) :

'E': EXCEPTION.
'W': WARNING.

QWACFLGS Flags: (Field name: QWACFLGS).

RES Wait ACE Ace that incurred a longest wait described in part 1 of DSNDQLLL (Field name: QLLLRACE).

RMID RMID. (Field name: QLLLID).

Rollup ID For rollup records, the type of rollup record (Field name: QLLLRUID):

'RU' = RRSAF and DDF rollup record.
'PQ' = Parallel query rollup record.
'AT' = Autonomous transaction rollup record.
' ' = No value set.

Service Task Begin Time Begin time for service task wait. (Field name: QLLLSBT).

Service Task Delta Time Delta time for service task wait. (Field name: QLLLSDT).

Service Task End Time End time for service task wait. (Field name: QLLLSET).

Service Wait ACE Ace that incurred a longest wait described in part 2 of DSNDQLLL (Field name: QLLLSACE).

Thread End Time Beginning store clock value (STCK) for the period covered by this accounting record. You can determine the elapsed time of the application by subtracting this field from QWACESC (ending store clock value). threads that do not terminate (such as CICS primed threads and IMS wait-for-input message regions) can have an ending clock value that includes the time the thread was inactive and waiting to perform work. (Field name: NTHETIME).

Thread Start Time Beginning store clock value (STCK) for the period covered by this accounting record. You can determine the elapsed time of the application by subtracting this field from QWACESC (ending store clock value). Threads that do not terminate (such as CICS primed threads and IMS wait-for-input message regions) can have an ending clock value that includes the time the thread was inactive and waiting to perform work. (Field name: NTHSTIME).

Thread Type Connecting system type code (in hexadecimal). This field can have a null value. For example, this field contains a null value for some utilities. (Field name: NTHATYPE).

Value	Utility
1	TSO foreground and background
2	Db2 call attach
3	DL/I batch
4	CICS attach
5	IMS attach BMP
6	IMS attach MPP
8	DRDA protocol
9	IMS control region
A	IMS transaction BMP
B	Db2 utilities
C	RRSAF

Wait Type Type of operation that incurred the longest wait time (Field name: QLLLTYP):

'01' = Log write I/O
'02' = DB2 - I/O
'03' = Synch DB reads with DASD cache hit
'04' = Sending of IRLM notify msg
'05' = Pageset/partition p-locks
'06' = Page p-locks
'07' = Other p-locks
'08' = Parent l-locks
'09' = Child l-locks
'0A' = Other l-locks
'0B' = DB2 - lock
'0C' = DB2 - latch
'0D' = DB2-read I/O under thread other than this one
'0E' = DB2-write I/O under thread other than this one
'0F' = Drain lock