maxlockwait
Set the period a database operation will wait for a database lock to be released.
USYS$Mnmemonic_PARAMS
= maxlockwait =
Seconds | -1
|
infinite
USYS$Mnmemonic_PARAMS
= mlw =
Seconds | -1
{ | infinite
}
Arguments
- Seconds—number of seconds
to wait for an existing lock to be released; must be >=
0
. -1
—the application waits forever for the lock to be released. UseInfinite
for MSS.
Use
Applies to |
Mnemonic |
Connector Syntax |
Default Value if not Set |
---|---|---|---|
DB2 connector |
DB2 |
|
Database-level lock timeout value. |
MS SQL connector |
MSS |
|
|
PostgreSQL connector |
PGS |
USYS$PGS_PARAM |
|
SQLite connector |
SLE |
|
|
Sybase connector |
SYB |
|
Database-level lock timeout value. |
Description
Setting maxlockwait overrides the database-level lock timeout.
If the lock is not released after the specified
number of seconds, the transaction fails with the following message: 2009 - Occurrence Locked
. If maxlockwait is 0
, the
transaction fails immediately.
MS SQL Server
If the lock timeout connector
option is specified, and it is less than maxlockwait (including
infinite
), then lock timeout overrides
maxlockwait. For more information, see lock timeout.
maxlockwait
USYS$DB2_PARAMS = isolation level:rs, maxlockwait: 5