This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

Analyze lock problems (Analyze contention)

A good way to begin analyzing lock problems is by using the:

  • IRLM Ultimate Holder List view (ILKULLST)
  • IRLM Wait With Ultimate Holder view (ILKULTWT)

You can also look at the Wait Time field in the ILKRGWT view. The Wait Time field shows you the extent of any problems that may exist (for example, how long the waiters for a resource have been waiting).

Related topic

Analyze-contention

To investigate a long wait time, you can hyperlink from the Wait Time field to access the IRLM Resource Lock List view (ILKRSLST), which shows who holds the resource that is being waited for and who else may be waiting for it.

The cause of a problem may be that the holder of the resource is also waiting for another resource. To see what the holder is waiting for, hyperlink from the holder’s Hold Time field in the ILKRSLST view. The hyperlink takes you to the ILKRGLST view, which provides a list of all locks held or waited for by that specific holder.

If you want to investigate further, hyperlink from the holder’s Wait Time field in the ILKRGLST view to see who holds the resource that the holder is waiting for. You can repeat this process until you find the original cause of the problem.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*