Specifying how long an idle thread can use resources

You can specify a limit for the amount of time that active distributed threads can use resources without doing any processing.

Procedure

To limit the amount of time that distributed threads can remain idle:

Specify a value other than 0 for the IDTHTOIN subsystem parameter (the IDLE THREAD TIMEOUT field on installation panel DSNTIPR)

Db2 detects threads that have been idle for the specified period, and Db2 cancels the thread. Because the scan occurs only at 2-minute intervals, your idle threads generally remain idle for somewhat longer than the value you specify.

The cancellation applies only to active threads. If your installation permits distributed threads to be inactive and hold no resources, those threads are allowed to remain idle indefinitely.

The default value is 0. That value disables the scan to time out idle threads. The threads can then remain idle indefinitely.