This menu function informs about the current locks and lock requests of the ADABAS server.
Example:
The upper part of the screen shows information about the average number of locks held and requested, the maximum number of locks held and requested, the number of collisions and escalations that have occurred, as well as the number of current row or table locks.
In the lower part of the screen, all current locks and lock requests are described in detail.
In addition to the table and row concerned, the kind of lock, the lock holder, and the lock holder's terminal are shown.
Share locks protect used data against modifications while being accessed. Other users can only read-access data thus locked.
The displayed exclusive locks prevent other users from accessing the same data. Not even read-access is possible. If exclusive locks are held for a longer time, they are disadvantageous for the user. In this context, the parameters LOCK REQUEST TIMEOUT and LOCK INACTIVITY TIMEOUT are interesting. These timeout values that can be configured (see Section Info / Configuration ) serve to solve blocking and deadlock situations.
LOCK REQUEST TIMEOUT indicates the time a process may wait for the setting of a requested lock before it will be aborted.
LOCK INACTIVITY TIMEOUT indicates the time a process may hold locks without activities, before it will be rolled back automatically (ROLLBACK).