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.