LOCK TIMEOUT MAX (SPREG_LOCK_TIMEOUT_MAX subsystem parameter)
The SPREG_LOCK_TIMEOUT_MAX subsystem parameter controls the value that can be specified in a SET CURRENT LOCK TIMEOUT statement.
| Acceptable values: | -1–32767 |
|---|---|
| Default: | -1 |
| Update: | option 32 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM SPREG_LOCK_TIMEOUT_MAX |
| Data sharing scope: | Member |
| Online changeable | Yes |
| z/OSMF variable: | LTMX |
- -1
- Any supported value can be specified in a SET CURRENT LOCK TIMEOUT statement. -1 is the default value.
- 0–32767
- The maximum value that can be specified in a SET CURRENT LOCK TIMEOUT statement.
If the value of the SPREG_LOCK_TIMEOUT_MAX subsystem parameter is set to -1, unlimited waiting is allowed. However, if SPREG_LOCK_TIMEOUT_MAX is set to any value other than -1, Db2 enforces the specified limit by returning an error any SET CURRENT LOCK TIMEOUT statement that specifies the following values:
- Integer values greater than the SPREG_LOCK_TIMEOUT_MAX value
WAIT -1WAITwith no integer value is specifiedNULLif the SPREG_LOCK_TIMEOUT_MAX value is less than the IRLMRWT value
For more information, see SET CURRENT LOCK TIMEOUT statement.
