Number of lock escalations (NumLockEscals)

This parameter displays the number of times that row locks have been escalated to a table lock, including exclusive lock escalations. This parameter value is useful in determining the correct setting for the locklist and maxlocks configuration parameters.

Excessive lock escalations can occur if:

• The lock list size (locklist) is insufficient for the number of concurrent applications running
• The amount of lock list reserved for each application's use (determined by the maxlock parameter) is too small
• One or more applications are using an excessive number of locks.

Recommendation:

Most of the problems associated with the NumLockEscals parameter can be corrected by:

• Increasing the value in the locklist configuration parameter
• Increasing the value in the maxlocks configuration parameter
• Identifying applications that are using a large amount of locks and modifying them so that they use table locking rather then row locking. Using this approach could cause an increase in lock waits and time waited on locks, so care should be taken when modifying applications.

Default parameter attributes

TrueSight/ BMC Helix Operations Management properties