TIMEOUT—Lock timeout interval
Use the Modify Timeout Value panel or the TIMEOUT command to specify the resource timeout interval (the length of time (in seconds) that a thread waits for an unavailable resource before it is terminated).
This value should, in general, be larger than the average time between two consecutive commits to allow a user to wait long enough for a resource until it is freed at commit time. The new value takes effect immediately.
Modify Timeout Value panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : LOCK TIMEOUT INTERVAL
Type the new IRLM interval timeout value that you wish to change to. Then press Enter. The timeout value must be an exact multiple of the deadlock cycle time.
IRLM Interval Parameter
Timeout value . . . . . . . _____ (1-3600 or delta)
Command syntax and parameters
Value | Description |
---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
value | The resource timeout value (the number of seconds a thread waits for an unavailable resource before it is timed out). Specify one of the following values:
|
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
---|---|---|---|---|
Timeout value | DSNTIPI | IRLMWAIT | DSN6SPRM | IRLMRWT |