CICS Thread Summary

This panel provides an overview of DB2 thread activity that is originating from connected CICS® regions.

It provides information about the activity of each CICS region attached to Db2. It also presents information about individual CICS threads that are active in Db2. The display lines are ordered by thread elapsed time (total time since thread creation or reuse) and include information about the DB2 activity.

If monitoring a single remote DB2, the CICA command cannot display the information in this panel. The message Remote DB2 is not supported for this command is displayed.


 ________________ ZCICST   VTM     O2       V540.#P SE12 S 11/05/13 12:22:42 2 
> Help PF1      Back PF3       Up PF7      Down PF8     Sort PF10    Zoom PF11 
> T.C                                                                          
>         Thread Activity:  Enter a selection letter on the top line.          
                                                                               
> A-All-Idle    B-TSO      *-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  P-Worksta Q-All+Idle                    
===============================================================================
>                         CICS Thread Summary                                  
 CICA                                                                          
+ CICS            Total    DB2    Pct. of   Active     Commit    RO Commit     
+ RELS  Jobname    CPU     CPU    THRDMAX   Threads   Rate/sec   Rate/sec      
+ ----- --------  -----   -----   -------   -------   --------   ---------     
+ 6.8.0 CICSPO42  31.3%   00.0%      8.3%         1         .0          .0     
 THDC                                                                          
+*                                                                             
+Elapsed     Planname Tran CPU   Status       GetPg  Update Commit Corrid      
+----------  -------- ---- ----- ------------ ------ ------ ------ ------------
+00:00:30.4  QMF11    QMFE 30.6% IN-DB2       212573      0      0 POOLQMFE0003
+00:00:25.9  NPGM051  N051 00.0% WAIT-REUSE       35      1      1 ENTRN0510001
+00:00:24.7  NPGM044  N044 00.0% WAIT-REUSE       26      1      1 ENTRN0440002
===============================================================================

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 on CICS Thread Summary panel
Field	Exception	Reason
Jobname	ENTO	The number of transactions defined as ENTRY threads, overflowed, and waiting for POOL threads is high.
	ENTU	The percentage of available ENTRY threads is low.
	ENTW	The number of transactions waiting for ENTRY threads is high.
	POLU	The percentage of available POOL threads is low.
	POLW	The number of transactions waiting for POOL threads is high.
Total CPU	TCPU	The address space has excessive CPU utilization.
Db2 CPU	TCPU	The address space has excessive CPU utilization.
Pct. of THRDMAX	CICT	The number of threads active has reached the threshold percentage of the THRDMAX value.
Elapsed	ETIM	This thread has reached the Elapsed Time threshold value.
GetPg	GETP	The Getpage to Read I/O ratio indicates poor read efficiency.
Update	PGUP	The rate for system page updates is high.
Commit	COMT	The ratio of Commits to Updates indicates a low Commit frequency.

Navigation

For additional information about:

Which exceptions have tripped, type E.C to find out details.
The resource control table (RCT) for a specific CICS region, move the cursor to a CICS job name and press F11 (Zoom).
A particular thread, move the cursor to the thread information line and press F11 (Zoom).
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

CICS connection information:

CICS RELS

The CICS release of the connected CICS region:

6.6.0 for CICS Transaction Server 4.1: For CICS Transaction Server 4.1
6.7.0 for CICS Transaction Server 4.2: For CICS Transaction Server 4.2
6.8.0 for CICS Transaction Server 5.1: For CICS Transaction Server 5.1
6.9.0 for CICS Transaction Server 5.2: For CICS Transaction Server 5.2
7.0.0 for CICS Transaction Server 5.3: For CICS Transaction Server 5.3
7.1.0 for CICS Transaction Server 5.4: For CICS Transaction Server 5.4
7.2.0 for CICS Transaction Server 5.5: For CICS Transaction Server 5.5
7.3.0 for CICS Transaction Server 5.6: For CICS Transaction Server 5.6
7.4.0 For CICS Transaction Server 6.1: For CICS Transaction Server 6.1

Jobname

The job name of the connected CICS region.

For remote threads, this fields displays the correlation ID up to 8 characters.

Total CPU

The total CPU rate (percent) of the CICS region connected to Db2. This includes both TCB and SRB time.

Note: The following fields do not include data of parallel task threads that is initiated by another thread that is originating from the CICS connection:

Total CPU
Db2 CPU
Pct. of THRDMAX
Active Threads

Db2 CPU

The total CPU rate (percent) that is attributable to active threads originating from the CICS connection. This value is a subset of the total CICS region CPU utilization.

Pct. of THRDMAX

The percentage of THRDMAX (CICS maximum threads) that the current threads have reached.

Active Threads

The number of active threads originating from the CICS connection. This value includes outstanding Create Thread requests not yet satisfied by Db2. This value excludes threads originating from the CICS connection that are waiting for reuse.

Commit Rate/Sec

The number of Db2 Commits per second originating from the CICS connection.

The Commit rate is computed by determining the number of commits that occurred since the previous OMEGAMON® cycle divided by the elapsed time since the previous cycle.

RO Commit Rate/Sec

The number of Db2 read-only Commits per second originating from the CICS connection.

This rate is computed by determining the number of read-only Commits that occurred since the previous OMEGAMON cycle divided by the elapsed time since the previous cycle.

Note: The following fields do not include data of parallel task threads that is initiated by another thread that is originating from the CICS connection:

Total CPU
Db2 CPU
Pct. of THRDMAX
Active Threads

CICS thread information:

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

The Db2 plan name of the active thread.

Tran

The CICS transaction identifier active in the thread.

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

The CPU rate (percent) attributable to the thread.

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.

Status

The current Db2 status of the thread.

GetPg

The number of thread Getpage requests. This logical read request might not actually result in physical I/O if the requested page is currently in the buffer pool.

Update

The number of DB2 page updates made by the thread since thread creation. This value is incremented each time a row in a page is updated, not just once for each page updated. DB2 might update pages when it creates intermediate result tables because of a qualified SELECT statement, even though SELECT statements are generally thought of as read only operations. Pages that have been updated are written asynchronously by DB2, according to DB2's internal Deferred Write algorithm, not immediately after update or commit. DB2 resets the page update count at Create Thread and Signon. If Signon is not driven, the page update count is cumulative.

Commit

The number of times the thread successfully completed Commit processing.

Jobname | Corrid

You can customize this field by using the OMPEOPTS option CICSCORR. It shows one of the following field names:

Jobname: The jobname of the connected CICS region (by default).; For remote threads, this field shows the correlation ID up to 8 characters.
Corrid: The correlation ID of the CICS thread if OMPEOPTS member in RKD2PAR has the following setting: CICSCORR=YES.