POOLINAC—Pool thread timeout
Use the Modify Pool Thread Timeout panel or the POOLINAC command to specify the approximate time that a database access thread (DBAT) can remain idle in the pool before it is terminated. A database access thread in the pool counts as an active thread against maximum remote activity. The thread can hold locks, but it does not have any cursors.
If your site uses DDF thread pooling support (DDF type 2 inactive threads), you can set POOLINAC to a value greater than the typical inactive time to avoid the overhead that is required to create a new database access thread.
Modify Pool Thread Timeout panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : POOL THREAD TIMEOUT
Type the new pool thread timeout value that you wish to change to. Then press Enter.
Pool Thread Timeout Parameter
Seconds . . . . . . . . . . _____ (0-9999 or delta)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
value | Pool DBAT timeout value (the approximate time, in seconds, that a DBAT can remain idle in the pool before it terminates). Specify one of the following values:
|
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Seconds | DSNTIP5 | POOLINAC | DSN6FAC | POOLINAC |