Utility Detail Information

This panel provides detailed information about the activity of an individual utility. The information includes the relative utility statement position, the contents of the currently executing utility statement, and data specific to a particular utility.

For detailed information about a utility that has been started but not completed because of an abnormal termination (status UTIL-STOP on the Utility Summary panel), the Stopped Utility Detail Information panel is displayed.


 ________________ ZUTID    VTM     O2       V540./I SN13 07/10/13 15:56:35   2  
> Help PF1                                                            Back PF3  
                                                                                
>       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      
> K-PACKAGES      L-RES LIMIT   M-PARALLEL TASKS *-UTILITY      O-OBJECTS       
> P-CANCEL THREAD Q-DB2 CONSOLE R-DSN ACTIVITY   S-APPL TRACE   T-ENCLAVE       
> U-LONG NAMES                  W-ACCEL ACTIVITY                                
=============================================================================== 
>                         UTILITY DETAIL INFORMATION                            
 PLAN                                                                           
+ Thread:  Plan=DSNUTIL   Connid=UTILITY  Corrid=HONGLR13     Authid=HONG       
+ Attach:  UTILITY                                                              
+ Luwid=DEIBMIPS.IPSASN13.CBA38ED9219A=4407                                     
 utid                                                                           
+ Utility = RUNSTATS      Utilid = HONGR3RS                   Userid = HONG     
+ Phase   = RUNSTATS      Count  =          0                                   
+                                                                               
+ Current utility statement in sysin =    1                                     
+ Utility Statement:                                                            
+ RUNSTATS TABLESPACE RLOKDB13.RLOKT131 TABLE ALL INDEX ALL                     
===============================================================================

Navigation

For additional information about

related topics, select one of the options on 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.

Utility information:

Utility: The name of the Db2 utility.
UtilID: The identifier that defines the utility to DB2. Each utility that has been started and is not yet terminated must have a unique utility ID.
UserID: The authorization ID of the invoker of the DB2 utility.
Phase: The executing phase of the DB2 utility.
Count: The total number of items (such as records or pages) that have been processed. The type of item depends on the utility and its phase.
Share Level: The share level of the tablespace accessed by utilities. The share level can be exclusive control, share read access, or share write access.
Output data set: The name of the output data set currently in use. If the utility is not MERGECOPY or COPY, this field is not displayed.
Input data set: The name of the input data set currently referenced by the utility. If the utility is not LOAD, this field is not displayed.
Loading data records into table: The name of the table into which the data records are being loaded. If the utility is not LOAD, this field is not displayed.
Current utility statement in SYSIN: The utility statement that is currently in execution.
Utility statement: The contents of the executing utility statement.