Lock Wait Timeout (-SQLLockWaitTimeout)
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Use the Lock Wait Timeout(-SQLLockWaitTimeout) parameter to specify the number of seconds to wait when a
lock conflict occurs.
| Operating system and syntax | UNIX / Windows |
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| CC, DBS | — | — | 5 | 5 |
This value applies to all conflicts that occur while using SQL
applications. The default value is 5 seconds.
Note: Progress recommends
changing the value of Lock Wait Timeout(
-SQLLockWaitTimeout) to a higher value if your installation encounters a lot
of conflicts. The Lock Wait Timeout(-SQLLockWaitTimeout)
parameter may be modified while your database is online using PROMON or through the
_DbParams VST. This change will only take effect on the primary broker and its newly spawned
servers.