DB2 Thread Wait 2 Attributes

Use these attributes to view DB2 Thread Wait 2 information.

ACE Address The agent control element (ACE) (see QWHSACE) of the thread that is reported. The value in QWHSACE is the ACE of the IFI application that requested this trace record (Field name: QW0148AC).

Accelerator Wait Events The number of wait trace events that were processed for requests to an accelerator (Field name: QWACAACC).

Accelerator Wait Time The accumulated wait time for requests to an accelerator (Field name: QWACAACW).

Asynchronous IXL Events The number of wait trace events processed for asynchronous IXLCACHE/IXLFCOMP invocations. These are incremented by IFCID 329, which is not part of a begin/end pair, so this number represents the true number of events. It is not doubled, as other wait events are (Field name: QWAXIXLE).

Asynchronous IXL requests The waiting time of the asynchronous IXL requests (Field name: AQWAXIXL).

Authorization ID The primary authorization ID from connection or signon (Field name: UWHCAID). For z/OS operator commands and DB2 system internal agents, the value is SYSOPR. Secondary authorization IDs might be the RACF groups associated with this primary authorization ID. The SQL ID is initially set to this primary authorization ID. The connection authorization exit and the signon authorization exit can change the primary authorization ID so that it is not the same as the original primary authorization ID (QWHCOPID). Distributed authorization ID translation can also change the primary authorization ID.

Autonomous Procedure Events The number of autonomous procedures that were executed (Field name: QWACACNT).

For a non-rollup record, this value is the number of autonomous procedures that were executed.
For a parallel query rollup record, this value is 0.
For a ddf or RRSAF rollup record, this value is the number of autonomous procedures that were executed.

Autonomous Procedure The accumulated wait time for autonomous procedures to complete (Field name: QWACWAIT).

Child L-Lock Events The number of global contention wait events for child L-locks (Field name: ADLCSUSC).

Child L-Locks The accumulated wait time due to global contention for child L-Locks (Field name: QWACAWTK).

Claim Release Events The total number of suspensions until the claims are released (Field name: QWACARNC).

Claim Release The waiting time for a claim to be released (Field name: QW02542W).

Collection Name The collection name (Field name: UW0148CI).

Commit Phase 1 Write I/O Events The number of wait trace events processed for FORCE-AT-COMMIT. (Field name: QWAXFCCT).

Commit Phase 1 Write I/O The accumulated wait time for commit phase 1 database write I/O completion (Field name: QWAXAWFC).

Connection ID The connection name (Field name: QWHCCN). It is not valid on end of memory and reflects the z/OS home address space (ASID) connection name for:

Batch:

'BATCH'

TSO:

'TSO'

QMF

'DB2CALL'

Utility

'UTILITY'

DB2 internal

DB2 subsystem ID

IMS

IMS-ID

CICS

CICS-ID

RRSAF

'RRSAF'

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 The correlation ID value (Field name: QWHCCV).

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.

DB2 Subsystem The DB2 subsystem ID.

DB2 Version The DB2 version.

DSG Member Name The Data Sharing Group (DSG) member name.

Data Sharing Group The Data Sharing Group name.

End User ID The user ID of the end user's workstation (Field name: QWHCEUID). This can be different from the authorization ID used to connect to DB2. This field contains blanks if the client did not supply this information. If QWHCEUID OFF is not 0, this value is truncated.

Global Contention Events The number of suspensions caused by global lock contention. This value is only calculated if accounting class 3 is active and DB2 is a member of a data sharing group (Field name: ADGCSUSC).

Global Contention The total accumulated waiting time caused by the suspension of IRLM lock requests due to global lock contention in a data sharing environment that requires intersystem communication to resolve (Field name: ADGCSUST).

Interval Start The start time of this interval.

L-Lock Events The number of global contention waits for all L-locks (Field name: ADLKSUSC).

L-Locks The accumulated global contention wait time for all L-locks. (Field name: ADLKSUST).

Location Name The location name (Field name: UW0148LN). The location name contains the name of the local location or remote location, depending on where the thread executes a package. The following statements execute locally, regardless of the current package name:

COMMIT
ROLLBACK
SET <HOST VARIABLE> = CURRENT PACKAGE SET
SET <HOST VARIABLE> = CURRENT SERVER

For these statements, this field contains the location where the package executes, not the location where the statement executes.

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

A fully qualified network name (QW0148LM)
An LUW instance number (QW0148UV) and an LUW sequence number (see fields below).

It consists of two 8-character fields: QW0148NI and QW0148LM, which together uniquely identify a client system.

MVS System ID The MVS identifier.

Notify Messages Events The number of wait trace events processed for waits for sending messages to other members in the data sharing group. This value is calculated only if accounting class 3 is active and DB2 is a member of a data sharing group (Field name: QWACARNG).

Notify Messages The accumulated elapsed wait time caused by suspension for sending messages to other members in the data sharing group (Field name: QWACAWTG). One common use of intersystem message sending is when database descriptors are changed due to create, alter, or drop statements. This value is calculated only if accounting class 3 is active and DB2 is a member of a data sharing group.

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

Other L-Lock Events The number of global contention wait events for other L-locks (Field name: ADLOSUSC).

Other L-Locks The accumulated wait time due to global contention for other L-locks. (Field name: QWACAWTM).

Other P-Locks The accumulated wait time due to global contention for other P-locks (Field name: QWACAWTQ).

P-Lock Events The number of global contention waits for all P-locks. (Field name: ADPLSUSC).

P-Lock Other Events The number of global contention waits for other P-locks (Field name: ADPOSUSC).

P-Lock Page Events The number of global contention waits for page P-locks (Field name: ADPPSUSC).

P-Lock Pgset Part Events The number of global contention waits for pageset and partition P-locks (Field name: ADPSSUSC).

P-Locks Page The accumulated wait time due to global contention for page P-locks (Field name: QWACAWTO).

P-Locks Pageset Partition The accumulated wait time due to global contention for page set or partition P-locks (Field name: QWACAWTN).

P-Locks The accumulated global contention wait time for all P-locks (Field name: ADPLSUST).

Package ID The package ID (Field name: UW0148PN).

Page Latch Events The number of wait trace events processed for page latch contention (Field name: QWACARNH).

Page Latch The accumulated wait time because of page latch contention. For example, when runstats and copy utilities are run with the SHRLEVEL(CHANGE) option, they use a page latch instead of locking to serialize the collection of statistics or the copying of a page. You can reduce page latch contention by controlling the way you schedule your applications (Field name: QWACAWTP).

Parallel Sync Events The number of times that waits for parallel query processing to synchronize parent and child tasks were suspended (Field name: QWACPQSC).

Parallel Sync Time The accumulated wait time for parallel queries to synchronize parent and child tasks (Field name: QWACPQSW).

Parent L-Lock Events The number of wait trace events processed for waits for global lock contention for parent L-locks (Field name: QWACARNJ).

Parent L-Locks The accumulated wait time due to global contention for parent L-locks. Global contention occurs when intersystem communication is required to resolve an IRLM lock or change request. QPACAWTL contains the wait time due to local contention. Local communication does not require intersystem communication. It can be resolved by the local subsystem (Field name: QWACAWTJ).

Plan Name The plan name (Field name: QWHCPLAN). It shows a blank for a DB2 command thread; otherwise:

For SPUFI with cursor stability: 'DSNESPCS'
For SPUFI with repeatable read: 'DSNESPRR'
For TSO: the application plan name
For IMS: the application 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 that is 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)

QWACFLGS Flags (Field name: QWACFLGS).

Stored Procedure The total elapsed time spent waiting for an available TCB before the stored procedure could be scheduled. This time is calculated only if accounting class 3 is active (Field name: QWACCAST).

Stored Prodecure Events The number of times an SQL call statement had to wait for an available TCB before the stored procedure could be scheduled. This value is calculated only if accounting class 3 is active (Field name: QWACCANM).

Suspensions Class 3 Events The total number of class 3 suspensions (Field name: ADTSUSC).

TCP/IP LOB XML Events The number of wait trace events that were processed for waits for TCP/IP LOB or XML materialization (Field name: QWACALBC).

TCP/IP LOB XML Accumulated wait time for tcp/ip lob or xml materialization (Field name: QWACALBW).

Thread Type The 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: QWHCATYP).

Total Class 3 Time The waiting time for all types of class 3 suspensions by the originating task and parallel tasks, if parallelism is employed (Field name: ADTSUST).

Transaction Name The transaction or application name that the end user is running (Field name: QWHCEUTX). This identifies the application that is currently running, not the product that is used to run the application. This field contains blanks if the client did not supply this information.

Workstation Name The end user's workstation name (Field name: QWHCEUWN). This field contains blanks if the client did not supply this information.

Feedback