Global Lock Statistics Summary by Report Interval
This panel provides an overview of the global locking activity that was recorded during a series of report intervals.
________________ ZHGLS VTM O2 V540./C SE11 07/31/13 21:43:32 2
> Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11
> H.A.K
> Enter a selection letter on the top line.
>
> A-SUBSYSTEM SUPPORT B-BIND C-BUFFER POOL D-GROUP BP
> E-DISTRIBUTED DATABASE F-EDM POOL G-LOG MANAGER H-OPEN/CLOSE
> I-SQL/RID/PARALLEL/PROC J-LOCK/CLAIM/DRAIN *-GLOBAL LOCK L-DB2 COMMANDS
> O-OPTIONS
===============================================================================
> GLOBAL LOCK STATISTICS SUMMARY BY REPORT INTERVAL
HGLS
+ Collection Interval: 1 min Start: 07/31 20:41
+ Report Interval: 1 min Combine Level: NONE End: 07/31 21:43
+
+ Total Total Total Total Incompat False
+ Interval XES Reqs Suspends P-Locks Negotiate Retained Contention
+ ----------- -------- -------- -------- --------- -------- ----------
+ 07/31 21:43 66 0 0 0 0 .0%
+ 07/31 21:42 166 0 2 23 0 .0%
+ 07/31 21:41 217 15 48 0 0 .0%
+ 07/31 21:40 122 0 0 0 0 .0%
+ 07/31 21:39 124 0 0 0 0 .0%
+ 07/31 21:38 124 0 0 0 0 .0%
===============================================================================
Navigation
For additional information about
- a report interval, move the cursor to the line you want and press F11 (Zoom). Each date/time displayed reflects the end of an interval.
- related topics, select one of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- Collection Interval
- The time interval specified for the collection of near-term history data. This unit of time was specified when the Near-Term History Data Collector was started.
- Start
- The start time of the first interval in this display.
- Report Interval
- This field determines the report interval. It is set on the Near-Term History Report Option panel.
- Combine Level
- This field reflects the selected combine level.
If Combine Level is NONE, the report interval is the same as the collection
interval. Possible values:
- HOURLY
- Data will be reported in hourly intervals.
- NONE
- Data will be reported in the time unit specified by the collection interval.
- End
- The end time of the last interval in this display.
- Interval
- Provides the date and time that mark the end of the report interval.
- Total XES Requests
- The total number of lock, change, and unlock requests that were propagated to MVS either synchronously or asynchronously.
- Total Suspends
- The total number of XES requests that resulted in a suspension. This includes suspends for Internal Resource Lock Manager (IRLM) global contention, XES global contention, or false contention.
- Total P-Locks
- The total number of lock, change, and unlock requests for P-locks.
- Total Negotiate
- The number of times that this DB2 member was driven to negotiate a P-lock.
- Incompat Retained
- The number of global lock or change requests that failed because of an incompatible retained lock. Certain P-locks can be retained because of a system failure. Another DB2 member cannot access the data that the retained P-lock is protecting unless it requests a P-lock in a compatible state.
- False Contention
- The rate of false contentions to real contentions.