IRLM Resource Lock Summary view (ILKRSSUM)
- 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)
IRLM Resource Lock Summary view (ILKRSSUM)
- 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
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 |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*