Summary of Db2 Activity

This panel provides an overview of current Db2 activities and resource utilization, along with summaries of Db2 connection activities (grouped by connection types IMS, CICS®, TSO, batch, utilities, distributed, and stored procedures).


________________ ZSUMM    VTM     O2       V540.#P DA41 S MM/DD/YY  HH:MM:SS 2  
>       Help PF1                   Back PF3                    Zoom PF11        
> S.                                                                            
=============================================================================== 
>                          SUMMARY OF DB2 ACTIVITY                              
 DSYS                                                                           
+  SSAS+DBAS+IRLM+DIST CPU  =    00.0%       Thread Commit Rate  =      .0/sec  
+  Create Thread Rate       =      .0/sec    Thread Signon Rate  =      .0/sec  
+  Synch Read I/O Rate      =    26.0/sec    Prefetch Req Rate   =      .0/sec  
+  Update Request Rate      =  1291.5/sec    Write I/O Rate      =      .0/sec  
+  Getpages/Read I/O        =    95.35       Pages/Write I/O     =      .00     
+  Current Lock Suspensions =       0        Locking Timeouts    =       0      
+  Locking Deadlocks        =       0        Locking Escalations =       0      
+                                                                               
+  Connection Type     Connections  Threads   CPU    Getpage Rate  Elapsed Time 
+  ------------------  -----------  -------   -----  ------------  ------------ 
+  IMS                       0          0     00.0%        .0/sec   00:00:00.0  
+  CICS                      0          0     00.0%        .0/sec   00:00:00.0  
+  TSO Foreground            1          2     05.3%    3024.3/sec   00:01:05.8  
+  Batch                     3          7     00.2%        .0/sec   03-02:02    
+  Utilities                 0          0     00.0%        .0/sec   00:00:00.0  
+  Distributed               1          0     00.0%        .0/sec   00:00:00.0  
+  Stored Procedures         0          0     00.0%        .0/sec   00:00:00.0  
+  All Connections           5          9     05.5%    3024.3/sec   02-09:35    
===============================================================================

If in data sharing group mode or if monitoring a remote Db2, N/A is displayed for some of the fields.

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 Summary of Db2 Activity panel
Field	Exception	Reason
Synch Read I/O Rate	RIO	The synchronous RIO rate is high.
Prefetch Req Rate	PREF	The asynchronous prefetch request rate is high. Includes sequential, dynamic, and List Prefetch.
Current Lock Suspensions	SUSL	The total number of threads suspended waiting for locks is high.
Connections	IDFR	The total number of IDFORE connections is high.
Connections	IDBK	The total number of IDBACK connections is high.
Threads	TMAX	Number of active threads is high.
CPU	TCPU	CPU rate for threads in the connection type is high.
Getpage Rate	GETP	The Getpage to Read I/O ratio indicates poor read efficiency.
Utilities	UTIS	One or more utilities were started but did not complete running due to abnormal termination.

Navigation

For additional information about

a connection type, move the cursor to the connection line and press F11 (Zoom).
other topics, use the PF keys.

Fields

Db2 summary information: All rate information is computed by dividing the reported value by the elapsed time since the previous OMEGAMON® XE for Db2 PE cycle. For example, OMEGAMON XE for Db2 PE computes the synchronous Read I/O rate by dividing the number of synchronous Read requests since the previous OMEGAMON XE for Db2 PE cycle by the elapsed time since the previous cycle.

SSAS+DBAS+ IRLM+DIST CPU: The CPU rate (percent) used by these Db2 address spaces. It includes both TCB and SRB time. Db2 use of cross memory services causes the majority of Db2 CPU time to be attributed (by SRM) to the user's address space. Therefore, the CPU value does not include Db2 CPU time attributed to the user's address space as a result of cross memory services use.
Thread Commit Rate: The number of Commits per second.
Create Thread Rate: The number of Create Thread requests per second.
Thread Signon Rate: The number of Thread Signon requests per second. Thread signon processing is only applicable in the CICS and IMS Db2 attachment environments.
Synch Read I/O Rate: The number of synchronous Read I/Os per second.
Prefetch Req Rate: The number of Sequential Prefetch and List Prefetch requests per second.
Update Request Rate: The number of Update requests per second. The Update count is incremented each time a row in a page is updated.
Write I/O Rate: The number of Write I/Os per second. Write I/O is normally performed asynchronously. Updated pages are queued by the data set until written. Updated pages are physically written using the Db2 Deferred Write algorithm.
Getpages/Read I/O: The Getpage to Read I/O ratio. This value helps in measuring read and buffer pool efficiency The value is computed by dividing the total number of Getpage requests by the total number of synchronous read I/O requests since the last OMEGAMON XE for Db2 PE cycle.
Pages/Write I/O: The average number of pages written per Write I/O. This value is computed by dividing the number of pages written by the number of Write I/Os since the last OMEGAMON XE for Db2 PE cycle.
Current Lock Suspensions: The current number of threads that are waiting because of a lock request issued for a resource that is unavailable.
Locking Timeouts: The number of locking timeouts since Db2 was started. Timeouts occur because lock requests were suspended for a time in excess of the locking timeout value.
Locking Deadlocks: The number of locking deadlocks that occurred since Db2 was started. Deadlocks are a result of locking contention.
Locking Escalations: The number of lock escalations that occurred since Db2 was started. This count includes the number of escalations to both shared and exclusive modes.

Db2 connection information: A summary of connection information by Db2 connection type.

Connection Type: A single line is displayed for each Db2 connection type.
Connections: The number of active connections originating from the connection type. For Distributed, it is the count of remote Db2 connections in which the Db2 subsystem being monitored has active Db2-to-Db2 system conversations.; For remote Db2 subsystems and in Data Sharing Group mode, this field is marked as not available (N/A).
Threads: The number of active threads that are originating from the connection type. This number includes active parallel task threads that are initiated by threads that are originating from the connection type. For Distributed, it is the number of active database access threads that are active on the Db2 subsystem being monitored.
CPU: The total CPU rate (percent) attributable to the connection type. For non-CICS connection types, this value is the total CPU rate of all address spaces within the connection type with active threads. For CICS connections, this value is the total CPU rate attributable to all active threads originating from CICS connections.; For remote Db2 subsystems and in Data Sharing Group mode, this field is marked as not available (N/A).
Getpage Rate: The total Getpage rate per second for active threads originating from the connection type.
Elapsed Time: The average elapsed time for an active thread within the connection type. This value is computed by adding the elapsed time of all active threads within the connection type and dividing it by the total number of active threads.