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

DDTG DBI1 Modify Timeout Value
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

image2018-12-25_12-38-40.png

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:

  • A numerical value in the range 1–3600
  • A delta value
    Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 1–3600.

Note

The resource timeout value must be a multiple of the deadlock time.

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*