lock timeout
Set a time-out period for all transaction and query requests.
USYS$Mnemonic_PARAMS = lock timeout : Seconds | infinite
USYS$Mnemonic_PARAMS = locktime : Seconds | infinite
Use
| Applies to | Mnemonic | Connector Syntax |
|---|---|---|
| MS SQL connector | MSS | USYS$MSS_PARAMS
|
| PostgreSQL | PGS | USYS$PGS_PARAMS
|
Arguments
Seconds—maximum number of seconds to wait for a query to return results or a transaction to successfully complete; if not specified, the default is 10 seconds.
Description
Depending on the database configuration, a timeout may or may not be associated with an effective lock on the DBMS.
To specify the maximum time to wait for a lock, use the maxlockwait option.
