IDLE THREAD TIMEOUT field (IDTHTOIN subsystem parameter)
The IDTHTOIN subsystem parameter controls the amount of time, in seconds, that an active server thread is allowed to remain idle. If the IDTHTOIN value is non-zero, the value is also the timeout value for TCP/IP synchronous receive operations with distributed clients.
| Acceptable values: | 0–9999 |
|---|---|
| Default: | No timeout for idle thread timeout. 120 for TCP/IP synchronous receive operations. |
| Update: | Option 47 on panel DSNTIPB |
| DSNZPxxx: | DSN6FAC IDTHTOIN |
The amount of time, in seconds, that an active server thread is allowed to remain idle is known as the idle thread timeout value. The thread is canceled after the timeout value expires, and its locks and cursors are released. Threads are checked every two minutes to see if they have exceeded the timeout value. If the timeout value is less than two minutes, the thread might not be canceled if it has been inactive for more than the timeout value but less than two minutes.
Inactive and indoubt threads are not subject to timeout. The value that you specify for the DDF THREADS field determines whether a thread can become inactive, and thus not subject to timeout.
- For idle thread timeout, timeout processing is disabled, and idle server threads can remain in the system and continue to hold any resources.
- For TCP/IP synchronous receive operations, Db2 sets the timeout value to 120 seconds.
If the IDTHTOIN value is non-zero, Db2 also uses the IDTHTOIN value as the timeout value for TCP/IP synchronous receive operations. A Db2 server uses TCP/IP synchronous receive operations when the server determines that the requester has not yet sent it all the data for a DRDA request or for a LOB or XML object.
You can enable longer idle wait times for threads from specific remote applications, without increasing the system-wide limit for idle thread timeouts, by creating MONITOR IDLE THREADS profiles. The IDTHTOIN setting does not apply to any thread that qualifies for the filtering criteria of a MONITOR IDLE THREADS profile. For more information, see Monitoring remote idle threads by using profile tables.