Use the threshold to set the length of time, in milliseconds, a
transaction waits to obtain a lock. If the transaction attempting to obtain a lock conflicts
with another transaction's existing lock, it waits until the BLOCKING_TIMEOUT option threshold is reached. If the conflict still exists, the
transaction rolls back and you see an error.
Prerequisites
- SAP Sybase IQ server has a simplex database.
Task
Note: The default value, 0, indicates that a blocked transaction must wait indefinitely
until all conflicting transactions release their locks.
Set the BLOCKING_TIMEOUT database option value to the number of
milliseconds you want the transaction to wait for conflicting transactions to release
their locks.
set temporary option blocking_timeout = '400';
Note: The blocking option can be set either at the connection or PUBLIC
level.