Enclave Thread Summary

This panel provides an overview of the activity of all threads connected to Db2 having an associated enclave token.

The enclave token is associated with an individual thread. In Db2, stored procedure and DDF threads are classified into a Workload Manager (WLM) service class and assigned an enclave token. After the thread has been associated with a service class, it begins to receive resources according to the service class periods defined for the service class.

WLM makes "give" and "take" decisions about resources according to two things:

The defined importance for the service class period.
The computed performance index (PI) for the service class period.

The service class periods that have low importance and a low number for PI are likely to be considered as "DONORS" for WLM resources on a heavily loaded system.


________________ ZENCL    VTM     O2       V540./I SN13 S 07/10/13 16:12:04 2  
> Help PF1      Back PF3       Up PF7      Down PF8     Sort PF10    Zoom PF11  
> T.O                                                                           
>         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  *-Enclaves  P-Worksta Q-All+Idle                     
=============================================================================== 
>                         Enclave Thread Summary                                
 THDE                                                                           
+ *                                                                             
+ Elapsed      Plan     Jobname  AuthID   CPU   P/I   SvcClass Pd# Status       
+ ----------   -------- -------- -------- ----- ----- -------- --- ------------ 
+ 21:15:06.5   SN13UDF1 HONGRFUN HONG     00.0%   .29 PRDBAT   1   IN-USER-FUNC 
+ 00:02:53.0   DSNREXX  HONGSTP2 HONG     01.6%   .29 PRDBAT   1   IN-STOR-PROC 
+ 00:02:53.0   DSNREXX  HONGSTP1 HONG     01.3%   .29 PRDBAT   1   IN-STOR-PROC 
+ 00:02:52.9   DSNREXX  HONGSTP3 HONG     01.0%   .29 PRDBAT   1   IN-STOR-PROC 
===============================================================================

Each row displays information about an individual thread. The columns are ordered by Thread Elapsed Time (total time since thread creation or reuse), and includes information about the Elapsed Time, Plan Name, Jobname, AuthID, CPU%, Performance Index for the Service Class Period, Service Class Name, Service Class Period Number and Thread Status.

Highlighting

Highlighted fields indicate that exceptions related to those fields have tripped. To determine which exceptions have tripped, type E.A on the top line of the panel to display the Exception Messages for Thread Exceptions panel.

Navigation

For additional information about

detailed information about a thread, place the cursor anywhere on the data for that thread and press F11 (Zoom). This will display the Enclave Detail 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 on 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.

Planname or Package

The Db2 plan name (or package name) of the active thread. If you selected option T from the Realtime Main Menu, this panel shows the information by plan. If you selected option U, this panel shows the information by package.

Jobname

The name of the active job. For Distributed threads, this column might contain other identifying data, such as an executable program name.

For remote Db2 subsystems, the correlation ID is displayed instead of the job name.

AuthID

The Db2 thread authorization identifier of the active thread.

CPU (if monitoring a Db2 subsystem or a data sharing group member)

The CPU rate (percent) associated with the database access thread. For non-CICS threads, this is the CPU rate of the address space from which the thread originates. For CICS® threads, this is the CPU rate attributable to the thread originating from the CICS connection.

Db2 (if monitoring a data sharing group or remote Db2 subsystem while XCF component is not activated for remote CPU)

The Db2 subsystem name of the data sharing group member that is currently monitored.

You can use the Tab key to move to a detail line and to select this detail line for drill down.

P/I

The computed Performance Index for the Service Class Period. N/A in compatibility mode.

SvcClass

The Service Class name the enclave work has been classified into. N/A in compatibility mode.

Pd#

The Service Class Period Number for the enclave. N/A in Compatibility mode.

Status

The current Db2 status of the thread.