DDF THREADS field (CMTSTAT subsystem parameter)
The CMTSTAT subsystem parameter controls whether in-use database access threads (DBATS) can be pooled, for use by other connections, after they successfully commit or roll back. Threads cannot be pooled if they hold cursors, use defined temporary tables, or execute statements from the dynamic statement cache.
| Acceptable values: | ACTIVE, INACTIVE |
|---|---|
| Default: | INACTIVE |
| Update: | option 46 on panel DSNTIPB |
| DSNZPxxx: | DSN6FAC CMTSTAT |
Deprecated function: The CMTSTAT subsystem parameter is deprecated, which means that it might be removed eventually. Set the CMTSTAT value to INACTIVE. Although, the ACTIVE setting can sometimes provide limited CPU performance advantages, they are generally outweighed by increased use of other system resources and the lack of scalability for distributed application workloads. For the recommended alternatives to the ACTIVE setting, see Enabling KEEPDYNAMIC refresh for DBATs and Enabling high-performance DBATs.
- INACTIVE
- DBATs can be pooled for use by other connections after a successful commit or rollback. Db2 can use inactive connection support (sometimes called type 2 inactive threads) or inactive DBATs (sometimes called type-2 inactive threads). In most cases, this option improves resource usage because fewer threads can typically service more connections. For more information, see How DBATs process remote connections.
- ACTIVE (DEPRECATED)
- Threads remain associated with connections and are not pooled, even after they successfully commit or roll back and hold no cursors. If your installation supports many connections, specify INACTIVE instead.