IRLM Resource Lock Summary view (ILKRSSUM)
The IRLM Resource Lock Summary view (ILKRSSUM) shows which database resources are most contended for.
Degree of contention for a given resource is measured by number of regions waiting (Number Waiters field), longest wait times (Oldest Waiter field), and average wait times (Avg Wait field).
The ILKRSSUM view shows:
- Every resource held by any participant in an N-way data sharing group
- Every resource waited for by any participant
- The number of waiters
- The number of holders
You can also see the:
- Longest wait time
- Average wait time
- Longest hold time
You can hyperlink to the ILKRSSUM view from the Database Contention option in the following menus:
- IMS System Menu (EZIMSS)
- DBCTL DBA Easy Menu (EZIDBA)
- IRLM Statistics Menu (ILKMS)
COMMAND ===> SCROLL ===> PAGE
CURR WIN ===> 1 ALT WIN ===>
>M1 =ILKRSSUM==========I10X=====*========26MAR2009==16:24:50====MVIMS====D====0
- IRLM Resource Lock Summary
Related Views
. Regions in IRLM Wait . Holding Regions
. Resource Contention . IRLM Statistics
Database DCB/Area RBA/Type F G Highest Number Oldest Avg Number Oldest
Name -------- -------- - - State Waiters Waiter Wait Holders Holder
CUSTHDAM 1 00000D38 P G H-UPD 1 0.2 0.2 1 45.6
CUSTHDAM 1 000006A6 P G H-UPD 1 0.2
The following hyperlinks are provided on the view:
Hyperlink from | To access |
|---|---|
Database Name | Database I/O Activity for Physical Databases (IMS Systems) view (IDAPSUMR), where you can access database I/O activity information at the level of the physical database |
Number Waiters | IRLM Region Lock Wait List view (ILKRGWT), which lists all regions that are waiting for database resource locks |
Number Holders | IRLM Region Lock List view (ILKRGLST), which lists all locks held or waited for by all regions |
Related topic