POOL THREAD TIMEOUT field (POOLINAC subsystem parameter)
The POOLINAC subsystem parameter specifies the approximate time, in seconds, that a pooled database access thread (DBAT) can remain idle in the pool before it is terminated.
| Acceptable values: | 0–9999 |
|---|---|
| Default: | 120 |
| Update: | option 46 on panel DSNTIPB |
| DSNZPxxx: | DSN6FAC POOLINAC |
- 1–9999
- The approximate time in seconds that pooled database access threads (DBAT) can remain idle in the pool before being terminated. The default value is 120 seconds.
Threads are checked every two minutes to see if they have exceeded the timeout value. That is, if the timeout value is less than two minutes, threads might not be canceled if they remain inactive longer than the timeout value but less than two minutes.
- 0
Specifies that no time limit applies to pooled regular DBATs that remain idle in the pool. However, the default time limit of 120 seconds still applies to high-performance DBATs that remain idle the in pool. Tip: Although specifying 0 for the POOLINAC value means that no time limit applies to pooled regular DBATs, Db2 can still terminate pooled DBATs for other reasons. Db2 also sometimes prevents disconnected DBATs from being pooled in the first place, such as when the pool already has a sufficient number of pooled DBATs to process the existing inactive connections.
A DBAT in the pool counts as an active thread against the limit specified by the MAXDBAT subsystem parameter. These DBATs can hold locks but they do not hold any cursors.