Ingres 11.2 | Ways to Avoid Lock Delays

Database Administrator Guide > Database Administrator Guide > Understanding the Locking System > Ways to Avoid Lock Delays

Was this helpful?

Ways to Avoid Lock Delays

There are several approaches to prevent delays due to lock waits:

• Keep transactions as short as possible.

• SET LOCKMODE…READLOCK=NOLOCK, but be aware that "dirty reads" can occur.

• Use SET LOCKMODE...TIMEOUT=n to indicate how long to wait for a lock. The default (0) is to wait forever. If timeout occurs, an error is returned, which must be checked for in the application, and the current statement (not the transaction) is aborted.

For details on the SET LOCKMODE statement, see User-Controlled Locking--SET LOCKMODE.

Last modified date: 08/28/2024