IFCID 001 - Global DDF Data

Record Trace - IFCID 001 - Global DDF Data

The field labels shown in the following sample layout of Record Trace - IFCID 001 - Global DDF Data are described in the following section.

                                        GLOBAL DDF DATA

DBAT/CONN QUEUED-MAX ACTIVE                        0        CONN REJECTED-MAX CONNECTED                        0
CONN CLOSED - MAX QUEUED                           0        QUEUED CLIENT CONNECTIONS                          0

COLD START CONNECTIONS                             0        WARM START CONNECTIONS                             0
RESYNCHRONIZATION ATTEMPTED                        0        RESYNCHRONIZATION SUCCEEDED                        0

CUR TYPE 1 INACTIVE DBATS                          0        HWM TYPE 1 INACTIVE DBATS                          0
TYPE 1 CONNECTIONS TERMINAT                        0

CUR INACTIVE CONNS (TYPE 2)                        0        HWM INACTIVE CONNS (TYPE 2)                        0
CUR QU INACT CONNS (TYPE 2)                        0        ACC QU INACT CONNS (TYPE 2)                        0
   MIN QUEUE TIME                           0.000000        HWM QU INACT CONNS (TYPE 2)                        0
   MAX QUEUE TIME                           0.000000
   AVG QUEUE TIME                           0.000000

CUR ACTIVE AND DISCON DBATS                        0        HWM ACTIVE AND DISCON DBATS                        0
HWM TOTL REMOTE CONNECTIONS                        0

CUR DISCON DBATS NOT IN USE                        0        HWM DISCON DBATS NOT IN USE                        0
DBATS CREATED                                      0        DISCON (POOL) DBATS REUSED                         0
DBATS TERM SINCE DDF START                         0
DBATS TERM POOLINAC LIM EXC                        0        DBATS TERM REUSE LIMIT EXC                         0

CUR ACTIVE DBATS-BND DEALLC                        0        HWM ACTIVE DBATS-BND DEALLC                        0
CUR ACTIVE DBATS-BND KEEPDY                        0        HWM ACTIVE DBATS-BND KEEPDY                        0
DBATS SUSPEND PROF EXCEPT                          0        HWM DBATS SUSPEND PROF EXCEPT                      0 
ILOS CANCELS DECLINED                              0

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

QUEUED CLIENT CONNECTIONS

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 LIM EXC

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 EXC

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

DBATS SUSPEND PROF EXCEPT

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

Field Name: QDSTDBPQ

HWM DBATS SUSPEND PROF EXCEPT

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

Field Name: QDSTMDPQ

ILOS CANCELS DECLINED

The number of ILOS cancels declined due to CPU contention.

Field Name: QDSTNLSC