Global Lock Statistics Detail
This panel shows detailed information about global locking activity in a data sharing environment during a selected report interval.
________________ ZHGLD VTM O2 V540.#P SE12 DD/MM/YY 12:01:52 2
> Help PF1 Back PF3 Up PF7 Down PF8
>
> 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
> M-THREAD HISTORY
===============================================================================
> GLOBAL LOCK STATISTICS DETAIL
HGLD
+ Collection Interval: 1 min Start: 11/06 11:47
+ Report Interval: 1 min Combine Level: NONE End: 11/06 11:48
+
+ Total Global Contention = .0% P-Lock/Notify Engines = 500
+ False Contention = .0%
+
+ INTERVAL /MINUTE /THREAD /COMMIT
+ QUANTITY ( 1) ( 2) ( 7)
+ -------- ------- ------- -------
+ P-Lock Lock Requests 344 344.00 172.00 49.14
+ P-Lock Change Requests 158 158.00 79.00 22.57
+ P-Lock Unlock Requests 39 39.00 19.50 5.57
+
+ XES Lock Requests 1134 1134.00 567.00 162.00
+ XES Change Requests 181 181.00 90.50 25.86
+ XES Unlock Requests 749 749.00 374.50 107.00
+ XES Asynchronous Requests 0 .00 .00 .00
+ XES Sync to Async Conv 0 .00 .00 .00
+
+ Suspends-IRLM Global Contention 0 .00 .00 .00
+ Suspends-XES Global Contention 0 .00 .00 .00
+ Suspends-False Contention 0 .00 .00 .00
+
+ Negotiate Pageset P-Locks 0 .00 .00 .00
+ Negotiate Page P-Locks 0 .00 .00 .00
+ Negotiate Other P-Locks 0 .00 .00 .00
+ Negotiate P-Lock Change 0 .00 .00 .00
+
+ Incompatible Retained Locks 0 .00 .00 .00
+ Notify Messages Sent 106 106.00 53.00 15.14
+ Notify Messages Received 0 .00 .00 .00
+ Engine Not Available 0 .00 .00 .00
+ Very Conditional Rejections 0 .00 .00 .00
+
+ IRLM SYSTEM ACTIVITY COUNTERS
+ ------------------------------
+ CB Latch Cont. 1198 2 .01 .67 .01
+ Global Deadlocks 0 0 .00 .00 .00
+ Local Resource Cont. 1831 0 .00 .00 .00
+ Global Resource Cont. 10237 9 .04 3.00 .03
+ Cont. Exit Visits 9193 9 .04 3.00 .03
+ False Cont. 1212 1 .00 .33 .00
+ Plock Exit Visits 2221 4 .02 1.33 .01
+ Notify Exit Visits 81892 70 .33 23.33 .23
===============================================================================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 interval currently displayed.
- 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 interval currently displayed.
- Total Global Contention
- The percent of synchronous XES lock, change, or unlock requests that resulted in global contention.
- False Contention Percentage
- The rate of false contentions to real contentions. This number should be no more than 50%.
- P-Lock/Notify Engines
- The number of engines available for P-lock exit or notify exit requests.
For each of the following fields, the following statistics are provided:
- INTERVAL QUANTITY
- The amount of activities that occur during the interval.
- /THREAD
- Rate per thread. The number under /THREAD (in parentheses) is the number of Create Threads during the interval.
- /COMMIT
- Rate per Commit. The number under /COMMIT (in parentheses) is the number of Commit requests (including abort requests) during the interval.
- P-lock Lock Requests
- Number of lock requests for P-locks. A P-lock is a physical lock used only in a data sharing environment to provide consistency of data cached in different Db2 subsystems.
- P-lock Change Requests
- Number of change requests for P-locks.
- P-lock Unlock Requests
- Number of unlock requests for P-locks.
- XES Lock Requests
- The number of lock requests (both logical and physical) that were propagated to MVS XES synchronously under the caller's execution unit. This count does not include suspended requests. Only the most restrictive lock for a particular resource is propagated to XES and the coupling facility.
- XES Unlock Requests
- The number of unlock requests (both logical and physical) that are propagated to MVS XES synchronously under the caller's execution unit. This count does not include suspended requests.
- XES Change Requests
- The number of change requests (both logical and physical) that were propagated to MVS XES synchronously under the caller's execution unit. This count does not include suspended requests.
- XES Asynchronous Requests
- The number of L-locks and P-locks propagated to XES asynchronously. This occurs when a new inter-DB2 interest occurs on a parent resource or when a request completes after the requestor's execution unit has been suspended.
- XES Sync to Async Conv
- The number of sync to async heuristic conversions for LOCK requests in XES. This conversion is done when XES determines that it is more efficient to drive the request asynchronously to the CF.
- Suspends-IRLM Global Contention
- The number of suspends due to Internal Resource Lock Manager (IRLM) global resource contentions. IRLM lock states were in conflict and inter-system communication is required to resolve the conflict.
- Suspends-XES Global Contention
- The number of suspends due to MVS XES global resource contentions that were not IRLM-level contentions. The XES lock states were in conflict, but the IRLM lock states were not.
- Suspends-False Contention
- The number of suspends caused by MVS XES false contentions. XES detects hash class contention when two different locks on different resources hash to the same entry in the coupling facility lock table. The requester is suspended until it is determined that no real lock contention exists.
- Negotiate Pageset P-Locks
- The number of times this Db2 member was driven to negotiate a pageset/partition P-lock because of changing inter-DB2 interest levels on the pageset/partition.
- Negotiate Page P-Locks
- The number of times this Db2 member was driven to negotiate a page P-lock because of inter-DB2 P-lock contention.
- Negotiate Other P-Locks
- The number of times this Db2 member was driven to negotiate a P-lock type other than pageset/partition or page.
- Negotiate P-Lock Change
- The number of times a P-lock change request was issued during P-lock negotiation.
- Incompatible Retained Locks
- 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.
- Notify Messages Sent
- The number of notify messages sent.
- Notify Messages Received
- The number of notify messages received.
- Engine Not Available
- The number of times an engine was not available for a P-lock exit or a notify exit request.
- Very Conditional Rejections
- The number of rejections of very conditional requests which could not get processed because of the heuristic algorithm used by XES.
IRLM System Activity Counters:
- CB Latch Cont.
- Active IRLM Control Block latch contention counter.
- Global Deadlocks
- Total number of global deadlocks.
- Local Resource Cont.
- Local resource contentions.
- Global Resource Cont.
- Global resource contentions.
- Cont. Exit Visits
- Visits to the contention exit, and IRLM granted the request. How many times lock contention was found and the request was sent to IRLM contention Exit, and the request was granted.
- False Cont.
- False contentions.
- Plock Exit Visits
- Plock Exit counter.
- Notify Exit Visits
- Notify Exit counter.