Thread History Package Detail
This panel provides detailed Accounting information on a program (package or DBRM) that has been executed by this thread.
It provides information collected for Accounting trace classes 7 and 8. If these traces are not active, this information is not available.
DB2® accounting
trace classes 7 and 8 must be started before the plan begins execution,
or package information is not displayed:
- If only class 7 was started, the In-DB2 Times fields display data, and N/A is displayed for the Waits and Count fields.
- If only class 8 was started, the Waits and Count fields display data, and N/A is displayed for In-DB2 Times fields.
________________ ZHTPKD VTM O2 V540./C DC11 03/18/16 23:02:39 2
> Help PF1 Back PF3 Up PF7 Down PF8
===============================================================================
> THREAD HISTORY PACKAGE DETAIL
HPLN
+ Thread: Plan=DISTSERV Connid=SERVER Corrid=db2jcc_appli Authid=HONG
+ Attach: APPLDIR DB2=DC11 MVS=PMO1
+ Dist : Type=DATABASE ACCESS, Luwid=G94C2ED3.E4F7.D076505438EB
+ Time : Start=03/18/2016 19:49:49.930017 End=03/18/2016 19:50:41.092444
pkd SYSLH200:NULLID:PMODC11
+ Program = SYSLH200
+ Type = ROLLUP PACKAGE Location = PMODC11
+ Token = 5359534C564C3031 Collection = NULLID
+
+ SQL Request Count = 30
+
+ In-DB2 Times Total
+ ------------------------------ ------------
+ Elapsed Time 00:00:00.045
+ CPU Time 00:00:00.017
+
+ Waits Count Total
+ ------------------------------ ---------- ------------
+ Synchronous I/O Wait 0 00:00:00.000
+ Asynchronous Read I/O Wait 0 00:00:00.000
+ Asynchronous Write I/O Wait 0 00:00:00.000
+ Local Lock/Latch Wait 0 00:00:00.000
+ Page Latch Wait 0 00:00:00.000
+ Drain Lock Wait 0 00:00:00.000
+ Drain of Claims Wait 0 00:00:00.000
+ DB2 Service Task Wait 0 00:00:00.000
+ Archive Log Mode(Quiesce) Wait 0 00:00:00.000
+ Archive Read from Tape Wait 0 00:00:00.000
+ Parallel Query Sync Wait 0 00:00:00.000
+ LOB Materialization Wait 0 00:00:00.000
+ Accelerator Wait 0 00:00:00.000
+ Pipe Wait 0 00:00:00.000
+ ------------------------------ ---------- ------------
+ Total Class 3 Wait Time 0 00:00:00.000
=============================================================================== 
Fields
Thread identifier: This information
identifies the thread to which the information in this panel applies.
- Plan
- The DB2 plan name of the active thread.
- Connid
- The DB2 connection identifier of the active thread.
- Corrid
- The DB2 correlation identifier of the active thread. If the correlation is not set, N/A is displayed.
- Authid
- The DB2 authorization identifier of the active thread.
- Attach
- Depending on the type of connection, the appropriate information is displayed.
- Attach information is displayed only if the thread is a distributed allied thread (not for distributed database access threads).
Attachment identifier:
- Connection Type
- The connection type is displayed in the first field:
- APPLDIR
- Application directed access (data base access threads)
- BATCH
- Other DB2 batch threads
- CALLATCH
- DB2 call attach
- CICS®
- CICS attach
- DLI
- DL/I batch
- IMSBMP
- IMS™ attach BMP
- IMSMPP
- IMS attach MPP
- IMSCTRL
- IMS control region
- IMSBMPB
- IMS transaction BMP
- RRSAF
- Recoverable Resource Manager Services Attachment Facility
- SYSDIR
- System directed access (data base access threads)
- TSO
- TSO foreground and background
- Utility
- Utility thread
- DB2
- The DB2 subsystem identifier.
- MVS™
- The MVS system identifier.
- ORIGAUTH
- The original (primary) DB2 authorization identifier of the thread. This field displays only when the original identifier is different from the Authid.
Time
identifier:
- Start
- The start date and time of this thread execution.
- End
- The end date and time of this thread execution.
Distributed
thread identifier: The following fields are displayed if the thread
has a distributed relationship with a remote DB2 subsystem.
- Type
- The distributed thread type.
- Distributed Allied
- A requesting thread; one that has issued an SQL call to a remote DB2 location.
- Database Access
- A responding thread; one that is serving a remote DB2 location by responding to an SQL call.
- DB2=
- The DB2 subsystem ID, indicating the member of the data sharing group of this thread.
- Luwid
- This value consists of two parts: the logical unit
of work ID (luw-id) and a token. The token can be used in place of
the luw-id in any DB2 command
that accepts luw-id as input. Format:
luw-id=tokenThe luw-id consists of the network name, the originating VTAM® LUNAME, and a unique identifier (separated by periods). Thus, the Luwid field displays data like in the following example:
USCACO01.O2D22A.A1FE8E04B9D4=8 - System
- The originating DB2 job name and the resource manager that is the source of the thread. An additional line below the Attach line identifies the user thread, if any, being served by the system thread.
Package information:
- Program
- The program name for which data is reported. Up to 18 characters of the package name are returned.
- Type
- The program type can be:
- PACKAGE
- DBRM
- PACKAGE-STORPROC, which means that the program is a package that was loaded by a stored procedure.
- Location
- The name of the location where the package is executed. For remote packages, times displayed represent the time spent locally to execute the remote package.
- Token
- The consistency token.
- Collection
- The package collection ID. This field is displayed only if the program type is PACKAGE.
- SQL Request Count
- The number of SQL statements issued. All DCL, DDL, and DML SQL statements as well as some Statistic Counters from DSNDQXST are included. COMMIT and ROLLBACK/ABORT are not included.
In-DB2 Times: In-DB2
times require an Accounting trace class 7. If this trace is not active, N/A is
displayed.
- In-DB2 elapsed time
- The elapsed time while processing this package or DBRM:
- Total
- The total time the thread spends processing this package or DBRM.
- Current®
- The total time spent processing the currently active SQL statement.
- In-DB2 CPU time
- The CPU time spent processing this package or DBRM.
- Total
- The total time the thread spends processing this package or DBRM.
- Current
- The total time spent processing the currently active SQL statement.
Waits: Wait times require an Accounting
trace class 8. If this trace is not active, N/A is
displayed. The following Statistics information is provided for each
field described below:
- Count
- The total number of waits.
- Total
- The total wait time.
- Synchronous I/O Wait
- Waits for synchronous I/O reads or writes.
- Asynchronous Read I/O Wait
- Waits for Read I/O performed under another thread (prefetch).
- Asynchronous Write I/O Wait
- Waits for Write I/O performed under another thread (deferred writes).
- Local Lock/Latch Wait
- Waits for locks or latches.
- Page Latch Wait
- Waits for page latch.
- Drain Lock Wait
- Waits to acquire DRAIN lock.
- Drain of Claims Wait
- Waits for claimers to be released after acquiring DRAIN lock.
- DB2 Service Task Wait
- Waits for DB2 services. The following types of DB2 services are included:
- Open/close of data set
- DFHSM recall of a data set
- SYSLGRNG update
- Define/extend/delete of data set
- Commit phase 2 for read only threads.
- Archive Log Mode(Quiesce) Wait
- Waits for MODE(QUIESCE) command to complete.
- Archive Read from Tape Wait
- Waits for read of archive log from tape.
- Parallel Query Sync Wait (QPAC_PQS_WAIT QPAC_PQS_COUNT)
- The amount of waits after parallel query processing suspended waiting for parent/child to be synchronized.
- This applies to DB2 11 and higher.
- LOB Materialization Wait (QPACALBW QPACALBC)
- Waits for TCP/IP LOB and XML materialization.
- Accelerator Wait (QWACAACW QPACAACC)
- The accumulated wait time for requests to an accelerator. DB2 11 and later.
- Pipe Wait (QOAC_PIPE_WAIT QPAC_PIPEWAIT_COUNT)
- The accumulated wait time for a pipe while this package is being executed. DB2 12 and
later.
- Total Class 3 Wait Time
- The total class 3 wait time.