Thread Package Summary

This panel shows a summary of activity that has occurred for all packages/DBRMs that have been executed by this thread.

It provides information collected for Accounting trace classes 7 and 8. If these Db2 traces are not active, this information is not available.

 
________________ ZPKG     VTM     O2       V540./C DB1H 07/31/13 13:45:16   2  
> Help PF1         Back PF3         Up PF7          Down PF8         Zoom PF11  
                                                                                
>       THREAD INFORMATION:  Enter a selection letter on the top line.          
                                                                                
> A-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS     D-LOCKS OWNED  E-GLOBAL LOCKS  
> F-CURRENT SQL   G-SQL COUNTS  H-DISTRIBUTED    I-BUFFER POOL  J-GROUP BP      
> *-PACKAGES      L-RES LIMIT   M-PARALLEL TASKS N-UTILITY      O-OBJECTS       
> P-CANCEL THREAD Q-DB2 CONSOLE R-DSN ACTIVITY   S-APPL TRACE   T-ENCLAVE       
> U-LONG NAMES                  W-ACCEL ACTIVITY                                
=============================================================================== 
>                           THREAD PACKAGE SUMMARY                              
 PLAN                                                                           
+ Thread:  Plan=DISTSERV  Connid=SERVER   Corrid=db2jcc_appli Authid=HONG       
+ Dist  :  Type=DATABASE ACCESS, Luwid=G9414E67.GE8B.CBBDD803F49D=78            
+ Location  :  ::FFFF:9.65.78.103                                               
+ Host Name:sig-9-65-78-103.mts.ibm.com                                         
 pkl                                                                            
 pkg                                                                            
+                                                                               
+                           SQL       In-DB2       In-DB2                In-DB2 
+ Package/DBRM         Requests Elapsed Time     CPU Time    Waits    Wait Time 
+ ------------------ ---------- ------------ ------------ -------- ------------ 
+*SYSLH200                    5 00:00:00.000 00:00:00.000      N/A          N/A 
===============================================================================

Highlighting

OMEGAMON® XE for DB2 PE highlights some fields in this panel to draw your attention to their current status:

Table 1. Highlighted fields in Thread Package Summary panel
Field	Exception	Reason
Plan	Any	Same as other thread detail panels.

Navigation

For additional information about

a specific package/DBRM, move the cursor to the required line and press F11 (Zoom). For more information, see the description of panel Package Detail.
related topics, select one of the options at the top of the panel.
other topics, use the PF keys.

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

Connection Type

Batch

The MVS jobname and ASID.

Note: For threads from remote Db2, the MVS job name is N/A.

CICS®

The CICS jobname, task name, task number, terminal ID, and thread type. The thread type is:

Pool: The thread in use is a pool thread.
Entry: The thread in use is a nonprotected entry thread.
Prot: The thread in use is a protected thread. Protected threads are defined in an RCT entry definition using the THRDS operand.

IMS

The IMS region number, transaction name, region name, and terminal ID (LTERM).

RRSAF

The MVS job name and ASID.

Note: For threads from remote Db2, the MVS job name is N/A.

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.

TSO

The TSO user ID and region ASID.

Utility

No additional information.

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.

Package identifier: This information identifies the package to which the information in this panel applies.

Package: The Db2 package name of the active thread. Up to 18 characters of the package name are returned.
Collection: The package collection identifier. This field is displayed only if a package is being used.

Distributed thread identifier: The following fields are displayed when 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.

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 such as the following:


USCACO01.O2D22A.A1FE8E04B9D4=8

Package list: For each entry in the package list, the display indicates the location, collection, and package that were bound into the plan.

Location: The name of the location where the package was bound. For remote packages, times displayed represent the time spent locally to execute the remote package.
Collection: The package collection identifier. This field is displayed only if a package is being used.
Package: The Db2 package name of the active thread. Up to 18 characters of the package name are returned.

Package/DBRM information:

Program: Program filtering input field. You can enter a specific package or DBRM that you want to display in the panel. You can use wildcard characters in this field. For example, enter DSNESM* to display all packages or DBRMs that begin with DSNESM.
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 elapsed time while executing in this package or DBRM. This field requires an Accounting trace class 7. If this trace is not active, N/A is displayed.
Total CPU Time: The total CPU time used while executing in this package or DBRM. This field requires an Accounting trace class 7. If this trace is not active, N/A is displayed.
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. This field requires an Accounting trace class 8. If this trace is not active, N/A is displayed.
Total Wait Time: The total time spent waiting for a class 8 event to complete while executing in this package or DBRM. This field requires an Accounting trace class 8. If this trace is not active, N/A is displayed.