Exclusive Lockwaits (SAP DB) (SAP Library

Exclusive Lockwaits (SAP DB)

This area in the Detail Analysis Menu provides information about all active and requested database locks.

Exclusive locks are used to prevent other users from accessing the locked entries. These locks can considerably reduce R/3 System and database system performance.

To access all the locked table entries, select Complete lock list.

The upper section of this screen (Lock List Statistics) provides information about the total number of available locks as well as locks currently set.

Below this information is more details about the individual locks currently set. The information includes the following:

Lock Type

LOCK ROW excl	One row in the table is locked
LOCK TAB excl	The entire table is locked

Timeout

This displays the time left until the lock is automatically released by the database system.

Request Timeout	The transaction responsible for the lock is terminated and reset.
Lock Timeout	The lockholder has not performed an action using the locked entry within a certain amount of time (the length of time is specified by the database parameter LOCK TIMEOUT).

Procedure to Determine the User that Triggered the Lock

In a database system belonging to an R/3 System the name of the user will always be SAPR3. The TASKID can be used to determine which R/3 work process has initiated the lock request.

Using this information and comparing it to the list of Database Processes), you can determine which user triggered the lock.

See also:

Locking Activity