In earlier versions of Adaptive Server and SQL Server, all commands that cannot immediately acquire a lock block, or wait, until the required lock is available. In version 11.9.2, the maximum length of time that a task waits can be specified on a server-wide or session-level basis. Processes that fail to acquire the lock within the specified waiting period fail with an error message.
For information on the new configuration parameter, lock wait period, see the System Administration Guide.
For information on the new set option, set lock wait, see the Adaptive Server Reference Manual.