DSNL092I ADBAT=adbat QUEDBAT=quedbat INADBAT=inadbat CONQUED=conqued

Explanation

This message is a section of output from the DISPLAY DDF command, which is part of message DSNL080I.

DSNL092I and DSNL093I: DBAT and connection information

If the DETAIL option was specified on the DISPLAY DDF command, the output also includes the following information:

  • The number of active, inactive, queued, and disconnected database access threads (DBATs)
  • The number of queued and inactive connections
DSNL092I ADBAT=adbat QUEDBAT=quedbat INADBAT=inadbat CONQUED=conqued
DSNL093I DSCDBAT=dscdbat INACONN=inaconn IUDBAT=iudbat
adbat
The current number of DBATs. This number includes DBATs that are actively associated with work for remote connections and disconnected DBATs.

This value increases as new DBATs are created or when inactive DBATs become active. This value decreases as DBATs terminate or become inactive or as disconnected DBATs terminate. When this value reaches or exceeds the MAXDBAT value, newly attached connections or new work on existing inactive connections or threads might be queued. This queueing occurs if no disconnected DBATs are available to service the work.

The MAXDBAT value is shown in message DSNL090I.

quedbat
The cumulative number of the following new work items that had to wait for a DBAT to become available:
  • Newly attached connections
  • New work on inactive connections
  • New work on inactive DBATs
  • Start of changeNew or existing work is suspended because it exceeded the exception threshold for the MONITOR THREADS keyword in a monitor profile.End of change
This value is a cumulative counter that is incremented for one of the following reasons:
  • The MAXDBAT limit is reached.
  • Start of changeAn exception threshold for the MONITOR THREADS keyword in the DSN_PROFILE_ATTRIBUTES table was exceeded. That exception threshold limits the concurrent number of DBATs for certain connections.End of change
This value corresponds to the QDSTQDBT field in IFCID 1. The quedbat counter is reset only when this Db2 subsystem is restarted.

A non-zero value suggests that performance and throughput might be affected. If so, consider increasing the MAXDBAT value.

The MAXDBAT value is shown in message DSNL090I.

inadbat
The current number of inactive DBATs (which were previously called type 1 inactive threads). This value applies only if the dt value in message DSNL090I indicates that DDF INACTIVE support is enabled.

For more information about any DBATs that are included in this number, look at the output from the DISPLAY THREAD command with the TYPE(INACTIVE) option. The DISPLAY THREAD output begins with message DSNV401I.

conqued
The current number of connection requests that are queued and are waiting to be serviced. This value applies only if the dt value in message DSNL090I indicates that DDF INACTIVE support is enabled.

These connections can be newly attached connections or inactive connections for which a new request arrived from the client. The number of inactive connections is shown in message DSNL093I.

These requests cannot be processed when one of the following conditions occur:
  • The maximum number of DBATs is reached, and no disconnected DBATs exist to process the request.

    The maximum number of threads is reached when the adbat value is equal to or greater than MAXDBAT value. (The MAXDBAT value is shown in message DSNL090I.) When this situation occurs, processing continues for these queued connections when another active DBAT releases its slot either by terminating or by moving to the inactive state.

  • Start of changeAn exception threshold will be exceeded for the MONITOR THREADS keyword in the DSN_PROFILE_ATTRIBUTES table if the connection request is processed.End of change
  • DDF is suspended or suspending. See the status value in message DSNL081I. Processing continues when DDF is started.
dscdbat
The current number of disconnected DBATs. This value applies only if the dt value in message DSNL090I indicates that DDF INACTIVE support is enabled.

This value indicates the number of DBAT pool threads. DBAT pool threads are the database access threads that are available to service queued connections requests. The DBATs that are included in this number are also accounted for in the adbat value.

Over time, disconnected DBATs can hold allocation duration locks. An allocation duration lock is a lock that persists across commit boundaries. This type of lock requires the connection to be deallocated or the thread to be enabled if it is inactive. You can release these allocation duration locks by terminating these DBATs. You can terminate disconnected DBATs by using one of the following methods:

  • Issue the STOP DDF command with the MODE(SUSPEND) option. Stopping DDF with MODE(SUSPEND) terminates these disconnected DBATs without affecting current or new connections. However, activity on these current or new connections is not processed until DDF is started.
  • Change the value of the POOLINAC subsystem parameter. This parameter controls the length of time after which unused disconnected DBATs are to be automatically terminated.
inaconn
The current number of inactive connections (which were previously called type 2 connections). This value applies only if the dt value in message DSNL090I indicates that DDF INACTIVE support is enabled.

This value represents connections with clients where the client last ended a unit of work either by a commit or rollback operation. This operation caused Db2 to change the state of the connection to inactive, which means that the DBAT is separated from the connection. The connection becomes inactive while the DBAT is made available to service new client connections or to service new requests on existing client connections.

This value is not included in the inadbat value. When a new request arrives from the client system on the connection, the connection is then moved to the conqued value.

For more information about any connections that are included in this number, look at the output from the DISPLAY THREAD command with the TYPE(INACTIVE) option. The DISPLAY THREAD output begins with message DSNV401I.

Start of changeiudbatEnd of change
Start of change

The current number of DBATs that are in use and processing client requests. This value applies only if the dt value in message DSNL090I indicates that DDF INACTIVE support is enabled

This value represents the difference between the adbat and dscdbat values.

End of change

Related information