Lock Manager Statistics Summary by Report Interval
This panel provides an overview of the locking activity that was recorded during a series of report intervals.
________________ ZHLKS VTM O2 V550.#P SE12 11/06/13 12:00:54 2
> Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11
> H.A.J
> 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 *-LOCK/CLAIM/DRAIN K-GLOBAL LOCK L-DB2 COMMANDS
> O-OPTIONS
===============================================================================
> LOCK MANAGER STATISTICS SUMMARY BY REPORT INTERVAL
HLKS
+ Collection Interval: 1 min Start: 11/06 11:44
+ Report Interval: 1 min Combine Level: NONE End: 11/06 12:00
+
+ Total Total Escalate Escalate
+ Interval Deadlocks Timeouts Suspends Lock Reqs to SHR to EXC
+ ----------- --------- -------- -------- --------- -------- --------
+ 11/06 12:00 0 0 9 1432 0 0
+ 11/06 11:59 0 0 12 227 0 0
+ 11/06 11:58 0 0 6 160 0 0
+ 11/06 11:57 0 0 6 156 0 0
+ 11/06 11:56 0 0 0 133 0 0
+ 11/06 11:55 0 0 0 140 0 0
+ 11/06 11:54 0 0 0 609 0 0
+ 11/06 11:53 0 0 0 144 0 0
+ 11/06 11:52 0 0 80 283 0 0
+ 11/06 11:51 0 0 40 287 0 0
+ 11/06 11:50 0 0 24 198 0 0
+ 11/06 11:49 0 0 54 271 0 0
+ 11/06 11:48 0 0 121 4185 0 0
+ 11/06 11:47 0 0 220 41511 0 1
+ 11/06 11:46 0 0 77 54719 0 0
+ 11/06 11:45 0 0 150 390 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.
- Deadlocks
- The total number of deadlocks detected during the interval.
- Timeouts
- The total number of times a suspension of a unit of work lasted longer than the Internal Resource Lock Manager (IRLM) timeout value.
- Total Suspends
- The total number of suspensions of a unit of work.
- Total Lock Reqs
- The number of requests to IRLM to obtain, change, query, and release locks, and also other IRLM requests.
- Escalate to SHR
- The number of times the allowable number of locks per tablespace was exceeded, causing a page (IS) lock to escalate to a shared (S) lock.
- Escalate to EXC
- The number of times the allowable number of locks per tablespace was exceeded, causing a page (IX) lock to escalate to an exclusive (X) lock.