Thread History Package Summary
This panel provides a list of programs (DMRMs or packages) that were executed by a completed thread.
Accounting classes 7 or 8 are required to display package information.
________________ ZHTPKG VTM O2 V550.#P SN12 11/06/13 15:25:47 2 > Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11 > THREAD HISTORY: Enter a selection letter on the top line. > A-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS D-GLOBAL LOCKS E-SORT/SCAN > F-DYNAMIC SQL G-SQL COUNTS H-DISTRIBUTED I-BUFFER POOL J-GROUP BP > *-PACKAGE SUMMARY L-RES LIMIT M-PARALLEL TASKS =============================================================================== > THREAD HISTORY PACKAGE SUMMARY HPLN + Thread: Plan=RUNSPNA9 Connid=DB2CALL Corrid=MISRSP9 Authid=MIS + Attach: CALLATCH DB2=SN12 MVS=PMO4 + Time : Start=11/06/2013 15:15:30.343017 End=11/06/2013 15:24:40.330325 + Luwid=DEIBMIPS.IPSATN12.CC3931107571 pkg + + SQL In-DB2 In-DB2 In-DB2 + Package/DBRM Requests Elapsed Time CPU Time Waits Wait Time + ------------------ ---------- ------------ ------------ -------- ------------ + SPNAT9_NEWNAME_TES 3 00:09:09.209 00:05:07.396 79 00:00:00.432 + RUNSPNA9 2 00:00:00.057 00:00:00.000 5 00:00:00.030 ===============================================================================
- The Db2 plan name of the active thread.
- The Db2 connection identifier of the active thread.
- The Db2 correlation identifier of the active thread. If the correlation is not set, N/A is displayed.
- The Db2 authorization identifier of the active thread.
- 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).
- Connection Type
- The connection type is displayed in the first field:
- Application directed access (data base access threads)
- Other Db2 batch threads
- Db2 call attach
- CICS attach
- DL/I batch
- IMS attach BMP
- IMS attach MPP
- IMS control region
- IMS transaction BMP
- Recoverable Resource Manager Services Attachment Facility
- System directed access (data base access threads)
- TSO foreground and background
- Utility thread
- The Db2 subsystem identifier.
- The MVS system identifier.
- The original (primary) Db2 authorization identifier of the thread. This field displays only when the original identifier is different from the Authid.
- The start date and time of this thread execution.
- The end date and time of this thread execution.
- 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.
- The Db2 subsystem ID, indicating the member of the data sharing group of this thread.
- 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:
The 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:
- 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.
- The name of the program for which data is reported. Up to 18 characters of the package name are returned. An asterisk (*) is displayed after the program name of the last executed program.
- SQL Requests
- The number of SQL statements issued in this package or DBRM.
- Total Elapsed Time
- The total Db2 time that has elapsed while executing in this package or DBRM.
- Total CPU Time
- The total Db2 CPU time used while executing in this package or DBRM.
- The total number of times that the thread had to wait for a class 8 event to complete while executing in this package or DBRM.
- Total Wait Time
- The total time spent waiting for a class 8 event to complete while executing in this package or DBRM.