Profile Monitoring Data

This topic shows detailed information about Statistics - Profile Monitoring Data.

System profile statistics from IFCID 402 trace data, about profile warnings or exception conditions, which occurred during the statistics interval.

Statistics - Profile Monitoring Data

The field labels shown in the following sample layout of Statistics - Profile Monitoring Data are described in the following section.


PROFILE MON. STATISTICS  VALUE                                                          
-----------------------  ----------------------------------------------------------------
PROFILE ID               66
TOKEN 1                  ::FFFF:10.15.60.170
TOKEN 2                  N/P
INTERVAL NUMBER          0
INTERVAL START           10/27/23 07:54:01.81
INTERVAL END             10/27/23 08:04:00.83
INTERVAL ELAPSED                  9:59.016024

PROFILE MON. STATISTICS                   QUANTITY    PROFILE MON. STATISTICS                 QUANTITY
----------------------------------------  --------    --------------------------------------  --------
THREAD EXCEPTION THRESHOLD EXCEEDED         108.8K    THREAD WARNING THRESHOLD EXCEEDED           0.00
  REQUEST FAILED                              0.00    CONNECTION WARNING THRESHOLD EXCEEDED       0.00
  QEUED/SUSPENDED                             0.00    IDLE THREAD WARNING THRESHOLD EXCEEDED      0.00
CONNECTION EXCEPTION THRESHOLD EXCEEDED       0.00
IDLE THREAD EXCEPTION THRESHOLD EXCEEDED      0.00

PROFILE MON. STATISTICS                      WARNINGS  EXCEPTIONS    PROFILE MON. STATISTICS            QUANTITY
-------------------------------------------  --------  ----------    ---------------------------------  --------
MONITOR REST CONNECTIONS FOR SECURITY            0.00        0.00    HWM THREADS SINCE DDF STARTED         21.00
MONITOR JDBC CONNECTIONS FOR SECURITY            0.00        0.00    HWM CONNECTIONS SINCE DDF STARTED     74.00
MONITOR CLI CONNECTIONS FOR SECURITY             0.00        0.00    CURRENT ACTIVE THREADS                 8.31
MONITOR DSN CONNECTIONS FOR SECURITY             0.00        0.00    CURRENT SUSPENDED THREADS              0.00
MONITOR DB2CONNECT CONNECTIONS FOR SECURITY      0.00        0.00    CURRENT NUMBER OF CONNECTIONS         19.03
MONITOR OTHER CONNECTIONS FOR SECURITY           0.00        0.00

PROFILE ID

The profile ID.

Field Name: QW0402PI

TOKEN 1

First token value. When the keywords value for a profile entry is monitor all threads or monitor all connections, this value is '::0'.

Field Name: QW0402TN1

TOKEN 2

Second token value.

Field Name: QW0402TN2

INTERVAL NUMBER

This counter shows how many times during statistic interval IFCID 402 warning and exception counters were reset when a new profile is enabled, or a threshold changed.

Field Name: SINTNUM

INTERVAL START

The start time of the period represented by this report or trace entry.

For a trace, it is the timestamp of the Db2 Statistics records pair which marks the beginning of the delta record represented by the trace entry.

For the group page of group-scope reports it is the beginning of the earliest interval across reported members.

For SAVE data, it is the timestamp of the first Db2 Statistics report pair used to derive a row in the statistics SAVE and FILE tables.

For FILE, it is the timestamp of the Db2 Statistics records pair which marks the beginning of the delta record represented by a row in the statistics SAVE and FILE tables.

Field Name: SDBEGREC

INTERVAL END

The end time of the period represented by this report or trace entry.

For a trace, it is the timestamp of the Db2 statistics records pair which marks the end of the delta record represented by the trace entry.

For the group page of group-scope reports it is the ending of the latest interval across reported members.

For SAVE data, it is the timestamp of the last Db2 statistics report pair used to derive a row in the statistics SAVE and FILE tables.

For FILE, it is the timestamp of the Db2 statistics records pair which marks the end of the delta record represented by a row in the statistics SAVE and FILE tables.

Field Name: SDENDREC

INTERVAL ELAPSED

The elapsed time of the period represented by this report or trace entry.

For a trace, it is the time elapsed between two consecutive Db2 statistics records pairs which mark the beginning and the end of the delta record represented by the trace entry. For a report, it is the elapsed time for the period within the interval record for which the Db2 statistics data is available.

For the group page of group-scope reports it is the average elapsed time of all the reported members.

Field Name: SDELTIME

THREAD EXCEPTION THRESHOLD EXCEEDED

Number of times that a thread exception threshold was exceeded.

Field Name: QW0402TE

REQUEST FAILED

Number of requests that failed because a thread exception threshold was exceeded.

Field Name: QW0402TF

QEUED/SUSPENDED

Number of threads that were queued or suspended when a thread exception threshold was exceeded. When the keywords value for a profile entry is monitor all threads, this value is 0.

Field Name: QW0402TQ

CONNECTION EXCEPTION THRESHOLD EXCEEDED

Number of times that a connection exception threshold was exceeded.

Field Name: QW0402CE

IDLE THREAD EXCEPTION THRESHOLD EXCEEDED

Number of times that an idle thread exception threshold was exceeded. When the keywords value for a profile entry is monitor all threads or monitor all connections, this value is 0.

Field Name: QW0402OE

THREAD WARNING THRESHOLD EXCEEDED

Number of times that a thread exception warning was exceeded.

Field Name: QW0402TW

CONNECTION WARNING THRESHOLD EXCEEDED

Number of times that a connection warning threshold was exceeded.

Field Name: QW0402CW

IDLE THREAD WARNING THRESHOLD EXCEEDED

Number of times that an idle thread warning threshold was exceeded. When the keywords value for a profile entry is monitor all threads or monitor all connections, this value is 0.

Field Name: QW0402OW

MONITOR REST CONNECTIONS FOR SECURITY - WARNING

Accumulated counter of MONITOR REST CONNECTIONS FOR SECURITY warnings.

Field Name: QW0402MCS_REST_W

MONITOR REST CONNECTIONS FOR SECURITY - EXCEPTION

Accumulated counter of MONITOR REST CONNECTIONS FOR SECURITY exceptions.

Field Name: QW0402MCS_REST_E

MONITOR JDBC CONNECTIONS FOR SECURITY - WARNING

Accumulated counter of MONITOR CLI CONNECTIONS FOR SECURITY warnings.

Field Name: QW0402MCS_CLI_W

MONITOR JDBC CONNECTIONS FOR SECURITY - EXCEPTION

Accumulated counter of MONITOR CLI CONNECTIONS FOR SECURITY exceptions..

Field Name: QW0402MCS_CLI_E

MONITOR DSN CONNECTIONS FOR SECURITY - WARNING

Accumulated counter of MONITOR DSN CONNECTIONS FOR SECURITY warnings.

Field Name: QW0402MCS_DSN_W

MONITOR DSN CONNECTIONS FOR SECURITY - EXCEPTION

Accumulated counter of MONITOR DSN CONNECTIONS FOR SECURITY exceptions.

Field Name: QW0402MCS_DSN_E

MONITOR DB2CONNECT CONNECTIONS FOR SECURITY - WARNING

Accumulated counter of MONITOR DB2CONNECT CONNECTIONS SECURITY warnings.

Field Name: QW0402MCS_DB2C_W

MONITOR DB2CONNECT CONNECTIONS FOR SECURITY - EXCEPTION

Accumulated counter of MONITOR DB2CONNECT CONNECTIONS SECURITY exceptions.

Field Name: QW0402MCS_DB2C_E

MONITOR OTHER CONNECTIONS FOR SECURITY - WARNING

Accumulated counter of other MONITOR CONNECTIONS FOR SECURITY warnings.

Field Name: QW0402MCS_DFT_W

MONITOR OTHER CONNECTIONS FOR SECURITY - EXCEPTION

Accumulated counter of other MONITOR CONNECTIONS FOR SECURITY exceptions.

Field Name: QW0402MCS_DFT_E

HWM THREADS SINCE DDF STARTED

Highest number of threads since DDF start.

Field Name: QW0402TH

HWM CONNECTIONS SINCE DDF STARTED

Highest number of connections since DDF start.

Field Name: QW0402CH

CURRENT ACTIVE THREADS

Current number of active threads.

Field Name: QW0402TC

CURRENT SUSPENDED THREADS

Current number of suspended threads.

Field Name: QW0402TS

CURRENT NUMBER OF CONNECTIONS

Current number of connections.

Field Name: QW0402CC