The information about database locking activity found in the Database Monitor, gives the maximum number of available database locks or entries, as well as the number used since database startup. If the number of locks set is close to the number of entries available, you may need to increase the value set for the maxlocks database configuration parameter.

The Escalations value displays the total number of rows locked by a single user session. If more than a certain percentage of the rows of a table are locked by a single user session, then the database system will lock the entire table. The threshold value for Escalations depends on the number of LOCKS available for the database instance.

A lock collision will occur when a request is issued for an object that is already locked. A high number of lock collisions indicates that either a lock is being held too long, or a database record is being accessed frequently by many users.

The Lockholder and Lock request values are indicators of the lock situation at the time the transaction was executed.

Exclusive Lockwaits