EXP Computer ThinConnect4 Guide de l'utilisateur télécharger pdf (Page 118)

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

1 2 ... 113 114 115 116 117 118 119 120 121 122 123 ... 162 163

Commentaires sur ces manuels

Pas de commentaire