Summary information |
|
|---|---|
Default value |
2147483647 |
Range of values |
0–2147483647 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
lock wait period limits the number of seconds that tasks wait to acquire a lock on a table, data page, or data row. If the task does not acquire the lock within the specified time period, Adaptive Server returns error message 12205 to the user and rolls back the transaction.
The lock wait option of the set command sets a session-level number of seconds that a task will wait for a lock. It overrides the server-level setting for the session.
lock wait period, used with the session-level setting set lock wait nnn, is only applicable to user-defined tables. These settings have no influence on system table.
At the default value, all processes wait indefinitely for locks. To restore the default value, reset the value to 2147483647 or use:
sp_configure "lock wait period", 0, "default"
