DSNL090I DT=dt CONDBAT=condbat MDBAT=mdbat

If the DETAIL option was specified on the DISPLAY DDF command, the output also includes subsystem parameter information that is associated with DDF:

DSNL090I DT=dt  CONDBAT=     condbat MDBAT=   mdbat

dt

The DDF threads value. This value corresponds to the CMTSTAT subsystem parameter.

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.

dt can have one of the following values:

A

DDF is configured with DDF THREADS ACTIVE.

I

DDF is configured with DDF THREADS INACTIVE.

condbat

The maximum number of inbound connections. This value corresponds to the CONDBAT subsystem parameter.

mdbat

The maximum number of database access threads (DBATs). This value corresponds to the MAXDBAT subsystem parameter.

This value determines the maximum number of active slots, which means the maximum number of concurrent active DBATs that can potentially execute SQL.

Related information

• DDF THREADS field (CMTSTAT subsystem parameter)
• MAX REMOTE CONNECTED field (CONDBAT subsystem parameter)
• MAX REMOTE ACTIVE field (MAXDBAT subsystem parameter)