Enabling high-performance DBATs

You can specify that Db2 uses high-performance database access threads (DBATs) to service remote server connections for distributed database applications.

Before you begin

Set the value of the CMTSTAT subsystem parameter to INACTIVE. If this parameter is set to ACTIVE, the PKGREL option of the MODIFY DDF command has no effect. For more information, see DDF THREADS field (CMTSTAT subsystem parameter).

About this task

A high-performance DBAT is a database access thread that stays associated with a remote connection at transaction boundaries, rather than being pooled. With high-performance DBATs, the amount of allocation and deallocation processing is reduced because the copy of the package remains allocated until the DBAT terminates.

Procedure

To enable the use of high-performance DBATs, complete the following steps:

Issue the MODIFY DDF command with one of the following PKGREL options:
- To specify that DBATs associated with connections are deallocated when the connection terminates, issue the following command:
```
MODIFY DDF PKGREL(BNDOPT)
```
- To specify that DBATs associated with connections are pooled when the connection terminates, issue the following command:
```
MODIFY DDF PKGREL(BNDPOOL)
```
For more information, see -MODIFY DDF command (Db2).
Bind at least one application package with the RELEASE(DEALLOCATE) bind option. For more information, see RELEASE bind option.

What to do next

The same behaviors that make high-performance DBATs advantageous for performance can also make package and DDL management more difficult as packages remain allocated and locks remain held for a longer duration. You might sometimes need to disable high-performance DBATs temporarily to complete such administration tasks. For more information, see Controlling deallocation for high-performance DBATs.