Lock Conflict situations

You can monitor the system to detect lock conflicts and lock elapsed time for transactions.

IMS_CMD_Lock_Wait_Time_Critical

Monitors the lock elapsed time for a transaction with a waiter lock status, and automatically issues a message when Lock_Elapsed_Time is greater than or equal to 7 seconds.

The formula is: IMS_Lock_Conflicts.Lock_Status EQ WAITER AND Local_LK_Conflict.Lock_Elapsed_Time GE 7 seconds, send the following message to user (xxxxxxx):“Lock Waiter elapsed time has exceeded the critical threshold.”

IMS_Lock_Conflict_TopBlocker

Monitors the system to detect lock conflicts and identifies the lock owner that is not waiting on other locks. This lock owner is considered the top blocker and should be examined to see if this conflict is impacting your system. If so, and the job does not need to be holding the locks, you might be able to cancel the job or transaction identified.

The formula is: IMS_Lock_Conflicts.Top_Blocker EQ Yes