POOL THREAD TIMEOUT field (POOLINAC subsystem parameter)
The POOLINAC subsystem parameter specifies the approximate time, in seconds, that a database access thread (DBAT) can remain idle in the pool before it is terminated.
Acceptable values: | 0 to 9999 |
Default: | 120 |
Update: | option 32 on panel DSNTIPB |
DSNZPxxx: | DSN6FAC POOLINAC |
A database access thread in the pool counts as an active thread against MAX REMOTE ACTIVE and can hold locks, but does not have any cursors.
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.
Specifying 0 causes a DBAT to terminate rather than go into the pool if the pool has a sufficient number of threads to process the number of inactive DBATs (type 2 inactive threads) that currently exist.