IRLM Region Lock Wait List view (ILKRGWT)
The IRLM Region Lock Wait List view (ILKRGWT), provides a list of all regions that are waiting for database resource locks. Regions with the longest waits are shown at the top.
The view shows:
- Every resource lock waited for by any region
- How long any region has been waiting for any lock
The ILKRGWT view is a good starting place for analyzing lock problems. The view highlights problems and shows their extent. You can hyperlink from the view to determine the cause of a problem.
You can hyperlink to the ILKRGWT view from the:
- Regions Waiting option in the IMS System Menu (EZIMSS)
- Regions in Lock Wait option in the DBCTL Operations Menu (EZDOPSR) and the DBCTL DBA Easy Menu (EZIDBA)
- Locking Contention option in the DBCTL Dashboard Menu (DBCMDASH)
- Locking field in the DBCTL Dashboard Menu (DBCMDASH)
- Regions in IRLM Wait option in the IRLM Statistics Menu (ILKMS)
- Number Waiters field in the ILKRSSUM view
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =ILKRGWT===========I12YIMS==*========02AUG2011==13:17:14====MVIMS====D====2
- IRLM Region Lock Wait List
Related Views
. Holding Regions . Database Contention
. Resource Contention . IRLM Statistics
Rgn IMS Rgn Rgn Rgn Database DCB/Area RBA/Type F G Cur Wait IRLM
ID ID Jobname Typ Status Name -------- -------- - - Sta Time ID
4 I12Y I12YBMP2 BMP WT-IRLM CUSTHDAM 1 00001A6C P G UPD 23.9 IR2G
2 I12Y IMSM12X MPP WT-IRLM CUSTHDAM 1 00001A6C P G UPD 21.1 IR2G
The following hyperlinks are provided on the view:
Hyperlink from | To access |
|---|---|
Rgn ID | 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. |
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. |
Wait Time | IRLM Resource Lock List view (ILKRSLST), where you can see all waiters and holders of a given resource |
Related topic