lock wait period

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"