RETAINED LOCK TIMEOUT field (RETLWAIT subsystem parameter)
When another Db2 subsystem in a data sharing group has failed, it can hold an incompatible lock on a resource. Locks that are held by failed Db2 members are called retained locks. The RETLWAIT subsystem parameter is used to calculate how long a transaction is to wait for a retained lock.
| Acceptable values: | 0–254 |
|---|---|
| Default: | 0 |
| Update: | option 32 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM RETLWAIT |
This value is of importance only in a data sharing environment.
The value that you use is a multiplier that is applied to the normal timeout value of the connection. For example, imagine that the retained lock multiplier is 2. The timeout period for a call attachment connection that is waiting for a retained lock is 1 * 2 (1 for the normal CAF timeout period, 2 for the additional time that is specified for retained locks).
If you use the default value, 0, applications do not wait for incompatible retained locks. Instead, the lock request is immediately rejected, and the application receives a resource unavailable SQLCODE.