Thread History

Use these attributes to view Db2 thread history.

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

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

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

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

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

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

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

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

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

  • 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'.
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.

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

  • 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
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).
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

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

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

QWACFLGS Flags: (Field name: QWACFLGS).

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

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

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

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

RMID RMID. (Field name: QLLLID).

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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