Threads Having Remote ID Information

This panel provides an overview of the activity of all threads connected to Db2 having an associated Workstation ID, End User User ID or End User Transaction ID.


________________ ZICLI    VTM     O2       V540./I SE11 S 07/10/13 16:13:52 2 
> Help PF1      Back PF3       Up PF7      Down PF8     Sort PF10    Zoom PF11 
> T.P                                                                          
>         Thread Activity:  Enter a selection letter on the top line.          
                                                                               
> A-All-Idle    B-TSO      C-CICS      D-IMS     E-Background   F-Dist Allied  
> G-Dist DBAC   H-Util     I-Inact     J-Filter  K-Functions    L-Stored Proc  
> M-Triggers    N-Sysplex  O-Enclaves  *-Worksta Q-All+Idle                    
===============================================================================
>                  Threads Having Remote ID Information                        
 THDP                                                                          
+ *                                                                            
+ Elapsed      WorkStation ID     End User UserID  End User Transaction Name   
+ ----------   ------------------ ---------------- ----------------------------
+ 01:44:03.1   RRSAF              OMPEUSER         OMEGAMON                    
+ 01:43:50.3   MyWorkstationName- MyUserID-this is MyApplicationInformation-als
+ 01:43:48.6   LW-LONG-WORKSTATIO LU-LONG-USER-ID- LP-LONG-APPLICATION-NAME-THA
+ 01:43:03.9   IBM-67119346B51    hong1            db2bp.exe                   
+ 01:36:00.5   LW-LRSF1-WORKSTATI LU-LRSF1-USER-ID LP-LRSF1-APPLICATION-NAME-TH
+ 01:18:53.8 P BATCH              HONG             HONGPTS1                    
+ 01:18:52.8 * BATCH              HONG             HONGPTS1                    
===============================================================================

Each row provides information about an individual thread, including information about thread response time, Db2 and MVS resource consumption, and DB2 activity. The columns are ordered by Thread Elapsed Time (total time since thread creation or reuse).

Navigation

For additional information about

a particular thread, move the cursor to the thread information line and press F11 (Zoom).
exceptions that have tripped, type E.A on the top of the panel.
A different Db2 subsystem, data sharing group, or member of a data sharing group, enter the name of a DB2 subsystem, group, or member in the topmost row and press Enter.
related topics, select one of the options at the top of the panel.
other topics, use the PF keys.

Fields

Elapsed

The elapsed time since thread creation, or since Db2 signon if the thread is reused. When the elapsed time of the thread exceeds 24 hours, the format is dd-hh:mm.

If this thread is involved in parallel processing or if it invoked autonomous procedures, one of the following identifiers is displayed after the elapsed time:

*: This thread is a parallel task that is initiated on behalf of another (originating) thread to process a query request in parallel.
O: This thread is the originating thread that invoked autonomous procedures.
P: This thread is the parent or the originating thread of the parallel tasks that are created to process a query request in parallel. Activity performed for this (originating) thread is reflected under the parallel tasks.
X: This thread is a parallel task that is initiated on behalf of another (originating) thread on another DB2 for sysplex parallelism.

Workstation ID

The end user's workstation name. This field contains blanks if the client did not supply this information.

End User UserID

The end user's workstation user ID. This can be different from the authorization ID used to connect to Db2. This field contains blanks if the client did not supply this information.

End User Transaction Name

The transaction or application name that the end user is running. This identifies the application that is currently running, not the product that is used to run the application. This field contains blanks if the client did not supply this information.