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. Use Infinite for MSS.

Use

Applies to

Mnemonic

Connector Syntax

Default Value if not Set

DB2 connector

DB2

USYS$DB2_PARAMS

Database-level lock timeout value.

MS SQL connector

MSS

USYS$MSS_PARAMS

1

PostgreSQL connector

PGS

USYS$PGS_PARAM

10

SQLite connector

SLE

USYS$SLE_PARAMS

1

Sybase connector

SYB

USYS$SYB_PARAMS

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

Related Topics