Specifying how long utilities wait for resources

You can specify how long Db2 waits before timing out utilities that wait for locks.

Procedure

To specify the operation multiplier for utilities that wait for drain locks, transaction locks, or claims to be released:

Specify the value of the UTIMOUT subsystem parameter. The UTIMOUT subsystem parameter specifies how long that a utility or utility command waits for a resource. That is, it specifies how long a utility or utility command waits until a lock or all claims on a resource of a particular claim class is released. The resulting wait time is the UTIMOUT value multiplied by the IRLMRWT subsystem parameter value.

For example, if you use the default value of 6, a utility can wait six times longer than an SQL application for a resource. This option allows utilities to wait longer than SQL applications to access a resource. For more information about setting the resource timeout for SQL applications, see the discussion of the RESOURCE TIMEOUT field (IRLMRWT subsystem parameter).