Timing out idle active threads

You can specify a time limit for active threads to remain idle.

About this task

When a thread remains idle longer than the specified limit, Db2 might cancel the thread. However, pooled and in-doubt threads are not canceled.

To specify limits for active idle threads:

Set the value of the IDTHTOIN subsystem parameter.
The timeout period is an approximation. If a server thread has been waiting for a request from the requesting site for this period of time, it is canceled unless the thread is currently pooled or in doubt thread. A value of 0, the default, means that the server threads cannot be canceled because of an idle thread timeout. You can specify a value in the range 0–9999 seconds.
Set a value for the TCPKPALV subsystem parameter.
A TCP/IP keep alive interval of 5 minutes or less, in conjunction with an IDTHTOIN value, can ensure that resources are not locked for a long time when a network outage occurs.