Global DDF Activity

Statistics - Global DDF Activity

The field labels shown in the following sample layout of Statistics - Global DDF Activity are described in the following section.

GLOBAL DDF ACTIVITY          QUANTITY  /SECOND  /THREAD  /COMMIT
---------------------------  --------  -------  -------  -------
DBAT/CONN QUEUED-MAX ACTIVE      0.00     0.00     0.00      N/A
CONN REJECTED-MAX CONNECTED      0.00     0.00     0.00      N/A
CONN CLOSED - MAX QUEUED         0.00     0.00     0.00      N/A
CONN CLOSED - MAX WAIT           0.00     0.00     0.00      N/A

COLD START CONNECTIONS           0.00     0.00     0.00     0.00
WARM START CONNECTIONS           0.00     0.00     0.00     0.00
RESYNCHRONIZATION ATTEMPTED      0.00     0.00     0.00     0.00
RESYNCHRONIZATION SUCCEEDED      0.00     0.00     0.00     0.00

CUR TYPE 1 INACTIVE DBATS        0.00      N/A      N/A      N/A
HWM TYPE 1 INACTIVE DBATS        2.00      N/A      N/A      N/A
TYPE 1 CONNECTIONS TERMINAT      0.00     0.00      N/A      N/A

CUR INACTIVE CONNS (TYPE 2)      0.02      N/A      N/A      N/A
HWM INACTIVE CONNS (TYPE 2)     14.00      N/A      N/A      N/A
ACC QU INACT CONNS (TYPE 2)      2.00     0.00      N/A      N/A
CUR QU INACT CONNS (TYPE 2)      0.00      N/A      N/A      N/A
  MIN QUEUE TIME             0.000109      N/A      N/A      N/A
  MAX QUEUE TIME             0.000109      N/A      N/A      N/A
  AVG QUEUE TIME             0.000109      N/A      N/A      N/A
HWM QU INACT CONNS (TYPE 2)      8.00      N/A      N/A      N/A

CUR ACTIVE AND DISCON DBATS      0.00      N/A      N/A      N/A
HWM ACTIVE AND DISCON DBATS     11.00      N/A      N/A      N/A
HWM TOTL REMOTE CONNECTIONS     14.00      N/A      N/A      N/A

CUR DISCON DBATS NOT IN USE      0.00      N/A      N/A      N/A
HWM DISCON DBATS NOT IN USE     11.00      N/A      N/A      N/A
DBATS CREATED                    1.00      N/A      N/A      N/A
DISCON (POOL) DBATS REUSED       1.00      N/A      N/A      N/A
DBATS TERM SINCE DDF START       0.00      N/A      N/A      N/A
DBATS TERM-POOLINAC              1.00      N/A      N/A      N/A 
DBATS TERM-REUSE LIMIT           1.00      N/A      N/A      N/A   

CUR ACTIVE DBATS-BND DEALLC      0.00      N/A      N/A      N/A
HWM ACTIVE DBATS-BND DEALLC      0.00      N/A      N/A      N/A

CUR ACTIVE DBATS-BND KEEPDY      0.00      N/A      N/A      N/A
HWM ACTIVE DBATS-BND KEEPDY      0.00      N/A      N/A      N/A

ILOS CANCELS DECLINED            0.00      N/A      N/A      N/A

CUR DBATS SUSPND PROF EXCEP      0.00      N/A      N/A      N/A
HWM DBATS SUSPND PROF EXCEP      0.00      N/A      N/A      N/A

DBAT/CONN QUEUED-MAX ACTIVE

The number of times a DBAT or connection was queued because it reached the ZPARM maximum for active remote threads (MAXDBAT).

Field Name: QDSTQDBT

CONN REJECTED-MAX CONNECTED

The number of connections that were rejected because the ZPARM limit for maximum remote connections (CONDBAT) was reached.

Field Name: QDSTQCRT

CONN CLOSED - MAX QUEUED

The number of queued client connections whose TCP/IP sockets were closed because the system parameter MAXCONQN was exceeded.

The socket close only occurs when the Db2 subsystem is a member of a data sharing group and Db2 was started with DDF THREADS set to INACTIVE.

Field Name: QDSTNCQC

CONN CLOSED - MAX WAIT

The number of queued client connections whose TCP/IP socket were closed due to system parameter MAXCONQW being exceeded.

The socket close only occurs when the Db2 subsystem is a member of a data sharing group and Db2 was started with DDF THREADS set to INACTIVE.

Field Name: QDSTNCCW

COLD START CONNECTIONS

The number of cold start connections with all remote locations (two-phase commit operations only).

Field Name: QDSTCSTR

WARM START CONNECTIONS

The number of warm start connections with all remote locations (two-phase commit operations only).

Field Name: QDSTWSTR

RESYNCHRONIZATION ATTEMPTED

The number of resynchronization connections attempted with all remote locations (two-phase commit operations only).

Background and Tuning Information

A large value can indicate network or system problems.

Field Name: QDSTRSAT

RESYNCHRONIZATION SUCCEEDED

The number of resynchronization connections that succeeded with all remote locations (two-phase commit operations only).

Background and Tuning Information

If the value of this field is much less than the number of resynchronizations attempted, network problems might exist.

Field Name: QDSTRSSU

CUR TYPE 1 INACTIVE DBATS

The current number of inactive DBATs type 1 (snapshot).

Field Name: QDSTQCIT

HWM TYPE 1 INACTIVE DBATS

The maximum number of inactive type 1 DBATs.

This value is a high-water mark.

Field Name: QDSTQMIT

TYPE 1 CONNECTIONS TERMINAT

The number of threads or connections that were terminated instead of being made type 1 inactive because the maximum number of type 1 inactive threads was reached (MAXTYPE1).

Field Name: QDSTNITC

CUR INACTIVE CONNS (TYPE 2)

The current number of type 2 inactive connections.

Field Name: QDSTCIN2

HWM INACTIVE CONNS (TYPE 2)

The maximum number of concurrent type 2 inactive connections that existed.

This value is a high-water mark for QDSTCIN2.

Field Name: QDSTMIN2

ACC QU INACT CONNS (TYPE 2)

The number of RECEIVE requests on type 2 inactive or new connections that are queued to be serviced by a disconnected (pooled) DBAT.

Field Name: QDSTQIN2

CUR QU INACT CONNS (TYPE 2)

The current number of type 2 inactive or new connections that are queued waiting for a database access thread (DBAT).

Field Name: QDSTNQR2

MIN QUEUE TIME

The minimum queue time of a type 2 inactive or new connection that was queued waiting for a database access thread (DBAT) in the last statistical period.

Field Name: QDSTNQMN

MAX QUEUE TIME

The maximum queue time of a type 2 inactive or new connection that was queued waiting for a database access thread (DBAT) in the last statistical period.

Field Name: QDSTNQMX

AVG QUEUE TIME

The average queue time of a type 2 inactive or new connection that was queued waiting for a database access thread (DBAT) in the last statistical period.

Field Name: QDSTNQAV

HWM QU INACT CONNS (TYPE 2)

The maximum number of type 2 inactive or new connections that are queued waiting for a database access thread.

This value is a high-water mark for QDSTNQR2.

Field Name: QDSTMQR2

CUR ACTIVE AND DISCON DBATS

The current number of active and disconnected (pooled) DBATs.

Field Name: QDSTCNAT

HWM ACTIVE AND DISCON DBATS

The maximum number of active and disconnected (pooled) DBATs that existed.

This value is a high-water mark for QDSTCNAT.

Field Name: QDSTHWAT

HWM TOTL REMOTE CONNECTIONS

The maximum number of active and remote connections. This value is a high-water mark.

Field Name: QDSTHWDT

CUR DISCON DBATS NOT IN USE

The current number of disconnected (pooled) DBATs that are available to process type 2 inactive or new connections.

Field Name: QDSTNADS

HWM DISCON DBATS NOT IN USE

The maximum number of disconnected (pooled) DBATs that are available to process type 2 inactive or new connections.

This value is a high-water mark for QDSTNADS.

Field Name: QDSTMADS

DBATS CREATED

The number of requests that required a database access thread (DBAT) to be created to process the request.

Note: This does not include database access threads created to replace disconnected (pooled) DBATs that terminated because they reached their reuse limit.

Field Name: QDSTNDBA

DISCON (POOL) DBATS REUSED

The number of requests that were satisfied by assigning a disconnected (pooled) DBAT to process the request.

Field Name: QDSTPOOL

DBATS TERM SINCE DDF START

The number of times that a DBAT has been terminated since DDF was started.

Field Name: QDSTNDBT

DBATS TERM-POOLINAC

The number of times that threads used by connections from the remote site were terminated after remaining in pool longer than POOLINAC.

Field Name: QDSTNTPL

DBATS TERM-REUSE LIMIT

The number of times that threads used by connections from the remote site were terminated after exceeding the number of times the thread can be reused.

Field Name: QDSTNTRU

CUR ACTIVE DBATS-BND DEALLC

The current number of DBATs that are active because the associated packages were bound with RELEASE(DEALLOCATE).

Field Name: QDSTNARD

HWM ACTIVE DBATS-BND DEALLC

The maximum number of DBATs that are active because the associated packages were bound with RELEASE(DEALLOCATE).

Field Name: QDSTMARD

CUR ACTIVE DBATS-BND KEEPDY

The current number of DBATS that are active due to usage of packages bound with KEEPDYNAMIC(YES).

Field Name: QDSTNAKD

HWM ACTIVE DBATS-BND KEEPDY

The maximum number of DBATS that are active due to usage of packages bound with KEEPDYNAMIC(YES).

Field Name: QDSTMAKD

ILOS CANCELS DECLINED

The number of ILOS cancels declined due to CPU contention.

Field Name: QDSTNLSC

CUR DBATS SUSPND PROF EXCEP

Current number of DBATs suspended due to system profile exception was reached.

Field Name: QDSTDBPQ

HWM DBATS SUSPND PROF EXCEP

Maximum number of DBATs suspended due to system profile exception was reached since DDF started.

Field Name: QDSTMDPQ