Database Administrator Guide > Database Administrator Guide > Understanding the Locking System > User-Controlled Locking--SET LOCKMODE
Was this helpful?
User-Controlled Locking--SET LOCKMODE
User-controlled locking is available through the SET LOCKMODE option of the SET statement. This option provides the following types of locking parameters:
• Locking behavior
• Locking mode requested when reading data
• Maximum number of page locks
• Maximum length of time a lock request can remain pending
IMPORTANT!  The SET LOCKMODE statement cannot be issued in a transaction.
For details on the SET LOCKMODE statement, see the SQL Reference Guide.
Last modified date: 04/03/2024