Entering content frame

Background documentation Exclusive Lock Locate the document in its SAP Library structure

When a transaction sets an exclusive lock on a database object, then the database object in question is available only to this transaction, and can only be changed by this transaction. Other transactions that check for exclusive locks or that want to set exclusive or shared locks conflict with the existing exclusive lock for this transaction. They are permitted neither shared nor exclusive access to the locked object.

Exclusive locks can be set for the database catalog, tables, or table rows.

An exclusive lock is implicitly released by the database system at the end of the transaction in question. It can also be released using the UNLOCK statement by the user. However, this is only possible when the database object has not been changed. If the database object has been changed using an SQL statement (for example, using the INSERT, UPDATE or DELETE statement), the exclusive lock remains in place until the end of the transaction.

See also:

Concepts of the Database System, Locks

 

 

 

Leaving content frame