IRLM Resource Lock List view (ILKRSLST)
The IRLM Resource Lock List view (ILKRSLST) shows all waiters for and holders of any database resource.
With the ILKRSLST view, you can see:
- Every resource lock held by any participant in an N-way data sharing group
- Every resource lock waited for by any participant
- How long a region has been waiting for a lock
- How long a region has been holding a lock
You can enter ILKRSLST on the COMMAND line to view a list of all resources contended for and their respective holders and waiters. If you are interested in a specific resource, you can hyperlink from the Wait Time field to see only waiters and holders for the specific resource.
You can hyperlink to the ILKRSLST view from the following views to see the waiters and holders for a selected resource only:
- Wait Time field in the ILKRGLST, ILKRGWT, and ILKRSWT views
- Num Held field in the ILKRGSUM view
COMMAND ===> SCROLL ===> PAGE
CURR WIN ===> 1 ALT WIN ===>
>M1 =ILKRSLST==========I10X=====*========26MAR2009==16:26:17====MVIMS====D====0
- IRLM Resource Lock List
Related Views
. Regions in IRLM Wait . Holding Regions . IRLM Statistics
. Resource Contention . Database Contention
CMD Database DBC/Area RBA/Type F G Cur Wait Hold Rgn IMS Rgn Rgn Rgn
--- Name -------- -------- - - Sta Time Time ID ID Jobname Typ Status
CUSTHDAM 1 00000D38 P G UPD 2.2 5 X19H IM81BMP1 BMP WT-IRLM
CUSTHDAM 1 000006A6 P G UPD 2.2 5 X19H IM81BMP1 BMP WT-IRLM
CUSTHDAM 1 00000D38 P G UPD 47.6 4 X19H IM81BMP2 BMP ACTV-USR
CUSTHDAM 1 DATASET B G RO 87.6 SYS X19H DLI -TCB SYS
COMMAND B G RO 180 SYS X19H DLI -TCB SYS
COMMAND F G RO 180 SYS X19H DLI -TCB SYS
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 |
Wait Time | Another version of the IRLM Resource Lock List view (ILKRSLST), where you can see all waiters and holders for a given resource |
Hold Time | IRLM Region Lock List view (ILKRGLST), where you can see all the resources held or waited for by a selected region This information is especially helpful for analyzing lock problems where a region holding requested resources is itself waiting for another resource. |
Rgn Jobname | Region/Thread Activity Detail view (DRGNDTLR) for DBT or ODB region types or Region Activity Detail view (IRGNDTLR) for all other region types DRGNDTLR and IRGNDTLR show what processing the region or thread has completed up until now. |
Related topic