Package Detail

This panel provides detailed information about the activity that has occurred for specific packages/DBRMs that have been executed by a particular thread.

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

 
________________ ZPKD     VTM     O2       V550./C DC11 03/18/16 22:41:17   2 
> Help PF1               Back PF3               Up PF7                Down PF8 
===============================================================================
>                               PACKAGE DETAIL                                 
 PLAN                                                                          
+ Thread:  Plan=DSNTEP12  Connid=BATCH    Corrid=HONGPTSK     Authid=HONG      
+ Attach:  BATCH          JOB Name=HONGPTSK                   JOB Asid=  50    
+ Package: DSN@EP2L                       Collection=DSNTEP2                   
+ Luwid=DEIBMIPS.IPSASE11.CB317E1DAB7C=1903                                    
 pkd  DSN@EP2L:DSNTEP2:PMODBE1                                                 
+ Program = DSN@EP2L                                                           
+ Type    = PACKAGE                Location   = PMODBE1                        
+ Token   = 192DF09416BC9902       Collection = DSNTEP2                        
+ Version = VBR1.PM59506                                                       
+                                                                              
+ SQL Request Count = 432380                                                   
+                                                                              
+ In-DB2 Times                                    Total           Current      
+ ------------------------------                  ------------    ------------ 
+ Elapsed Time                                    00:00:14.202    00:00:00.000 
+ CPU Time                                        00:00:11.150    00:00:00.000 
+                                                                              
+ Waits                                  Count    Total           Current      
+ ------------------------------    ----------    ------------    ------------ 
+ Synchronous I/O Wait                       0    00:00:00.000    00:00:00.000 
+ Asynchronous Read I/O Wait                 0    00:00:00.000    00:00:00.000 
+ Asynchronous Write I/O Wait                0    00:00:00.000    00:00:00.000 
+ Local Lock/Latch Wait                      0    00:00:00.000    00:00:00.000 
+ Page Latch Wait                            0    00:00:00.000    00:00:00.000 
+ Drain Lock Wait                            0    00:00:00.000    00:00:00.000 
+ Drain of Claims Wait                       0    00:00:00.000    00:00:00.000 
+ Global Parent L-lock Wait                  0    00:00:00.000    00:00:00.000
+ Global Child L-lock Wait                   0    00:00:00.000    00:00:00.000
+ Global Other L-lock Wait                   0    00:00:00.000    00:00:00.000
+ Global Pageset/Partition P-locks           0    00:00:00.000    00:00:00.000
+ Global Page P-lock Wait                    0    00:00:00.000    00:00:00.000
+ Global Other P-lock Wait                   0    00:00:00.000    00:00:00.000
+ Inter-System Message Send Wait             4    00:00:00.012    00:00:00.000 
+ DB2 Service Task Wait                      0    00:00:00.000    00:00:00.000 
+ Archive Log Mode(Quiesce) Wait             0    00:00:00.000    00:00:00.000 
+ Archive Read from Tape Wait                0    00:00:00.000    00:00:00.000
+ Parallel Query Sync Wait                 572    00:00:00.588    00:00:00.000 
+ LOB Materialization Wait                   0    00:00:00.000    00:00:00.000
+ Accelerator Wait                           0    00:00:00.000    00:00:00.000
+ Pipe Wait                                  0    00:00:00.000    00:00:00.000        
+ ------------------------------    ----------    ------------    ------------                
+ Total Class 3 Wait Time                    0    00:00:00.000    00:00:00.000
===============================================================================

Highlighting

The following table shows the fields that might be highlighted in the panel above to indicate that an exception that is related to this field exceeded its threshold value:

Table 1. Highlighted fields in Package Detail panel.
This table shows the fields and the exceptions these fields are related to. It also shows the reason for the corresponding exception.
Field	Exception	Reason
Plan	Any	Same as other thread detail panels.
Current Drain Lock Wait	WDLK	The thread reached drain lock wait threshold.
Current Drain of Claims Wait	WCLM	The thread reached wait for drain of claims threshold.
Current Service Task Wait	WSRV	The thread reached Db2 service wait threshold.
Current Archive Log Mode (Quiesce) Wait	WLGQ	The thread reached ARCHIVE LOG MODE(QUIESCE) wait threshold.
Current Stored Procedure Schedule Wait	WSPS	The thread reached the wait for stored procedure schedule threshold.
Current Global Lock Wait	WGLK	The thread reached the global lock wait threshold.

Navigation

To return to the Thread Package Summary panel, press F3.

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 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 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.
Current: The elapsed time waiting for the current event to complete.

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 (for example, list or Sequential Prefetch).

Asynchronous Write I/O Wait

Waits for Write I/O performed under another thread (for example, 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 claims to be released after acquiring drain lock.

Global Lock Wait

Waits for global locks in a data sharing environment.

Global Parent L-Lock Wait

Waits for global parent L-locks in a data sharing environment.

Global Child L-Locks (QWACAWTK QWACARNK)

Waits because of global contention for child L-locks.

Global Other L-Locks (QWACAWTM QWACARNM)

Waits because of global contention for other L-locks.

Global Pageset/Partition P-Locks (QWACAWTN QWACARNN)

Waits because of global contention for Pageset/Partition P-locks.

Global Page P-Locks (QWACAQTO QWACARNO)

Waits because of global contention for Page P-locks.

Global Other P-Locks (QWACAQTQ QWACARNQ)

Waits because of global contention for other P-locks.

Inter-System Message Send Wait

Waits for sending messages to other members in the data sharing group.

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.

Starting from Db2 11, waits that are associated with autonomous procedures are also included.

Archive Log Mode(Quiesce) Wait

Wait for ARCHIVE LOG MODE(QUIESCE) command to complete.

Archive Read from Tape Wait

Waits for read of archive log from tape.

Current I/O Wait Resource

If the thread is currently waiting for an I/O to complete, the resource will be identified here.

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.