Ingres 12.0 | User-Controlled Locking--SET LOCKMODE

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: 08/29/2024