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.