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
===============================================================================

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 (database 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
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=token

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:

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 summary:

Package/DBRM
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.
Waits
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.