User guide

1. A connection lockwait value as specified explicitly on the connection string will take
precedence over the server lockwait value but only for that one connection.
2. An explicit LOCKWAIT set on either the server or connection will take precedence
over the value set by the RDM$BIND_LOCK_TIMEOUT_INTERVAL logical
name.
3. The database-wide lock timeout interval if specified will place an upper limit on the
interval specified by the RDM$BIND_LOCK_TIMEOUT_INTERVAL logical name
or the LOCKWAIT on both the server and connection.
Example 1
RDM$BIND_LOCK_TIMEOUT_INTERVAL = 10
server LOCKWAIT = 20
connection LOCKWAIT = 30
LOCK TIMEOUT INTERVAL not specified
Results in a lockwait of 30.
Example 2
RDM$BIND_LOCK_TIMEOUT_INTERVAL = 10
server LOCKWAIT = 20
connection LOCKWAIT = 30
LOCK TIMEOUT INTERVAL = 25
Results in a lockwait of 25.
Example 3
RDM$BIND_LOCK_TIMEOUT_INTERVAL = 10
server LOCKWAIT = 20
connection LOCKWAIT = 30
LOCK TIMEOUT INTERVAL = 35
Results in a lockwait of 30.
Example 4
RDM$BIND_LOCK_TIMEOUT_INTERVAL = 10
server LOCKWAIT = 20
connection LOCKWAIT not specified
LOCK TIMEOUT INTERVAL not specified
Results in a lockwait of 20.
Example 5
RDM$BIND_LOCK_TIMEOUT_INTERVAL = 10
server LOCKWAIT not specified
connection LOCKWAIT not specified
LOCK TIMEOUT INTERVAL = 25
118