Remote Application Statistics

Statistics - Remote Application Statistics

The field labels shown in the following sample layout of Statistics - Remote Application Statistics are described in the following section.

REMOTE APPL. STATISTICS                                                  VALUE    REMOTE APPL. STATISTICS          QUANTITY
-----------------------  -----------------------------------------------------    -------------------------------  --------
APPLICATION NAME         REMOTEFLSAPPLICATION                                     REQUESTS                                 
PRODUCT ID               SQL00095                                                   COMMIT                             0.00
PRODUCT LEVEL            N/P                                                        ABORT                              0.00
                                                                                    REST SERVICE                       0.00
                                                                                    PROFILE SET SPECIAL REGISTERS      0.00
                                                                                    PROFILE SET GLOBAL VARIABLES       0.00
                                                                                                                           
REMOTE APPL. STATISTICS        QUANTITY    REMOTE APPL. STATISTICS    QUANTITY    REMOTE APPL. STATISTICS          QUANTITY
-----------------------------  --------    -------------------------  --------    -------------------------------  --------
DBAT NOT POOLED                            THREADS                                SERVER THREADS                           
  WITH HOLD CURSOR NOT CLOSED      0.00      QUEUED(PROFILE EXC)          0.00      ACTIVE                             0.00
  DGTT NOT DROPPED                 0.00      TERMINATED(PROFILE EXC)      0.00      INTERVAL HWM                       0.00
  KEEPDYNAMIC PACKAGES USED        0.00      ABENDED                      0.00      QUEUED(MAXDBAT)                    0.00
  HIGH-PERF DBAT USED              0.00      CANCELED                     0.00      TERMINATED                         0.00
  HELD LOB LOCATOR EXIST           0.00                                                 IDTHTOIN EXCEEDED              0.00
  STORED PROCEDURE COMMIT          0.00                                                 CANCELED                       0.00
                                                                                        IDLE THD PROF                  0.00
                                                                                        KEEP DYNAMIC REFRESH IDLE      0.00
                                                                                        KEEP DYNAMIC REFRESH USE       0.00
                                                                                        NETWORK                        0.00

APPLICATION NAME

The name of the application that is running at the remote site. This field contains the value of the CURRENT CLIENT_APPLNAME special register at the time of the initial connection, converted to uppercase. See the CURRENT CLIENT_APPLNAME topic in IBM documentation for more information.

Field Name: QLAPAPPN

PRODUCT ID

The product ID of the remote location from which the application connects. See QLAPPRLV for the product level.

Field Name: QLAPPRID

PRODUCT LEVEL

Product level, if known.

Field Name: QLAPPRLV

REQUESTS - COMMIT

Number of commit requests received from the requester (single-phase commit protocol) and committed requests received from the coordinator (two-phase commit protocol).

Field Name: QLAPCOMR

REQUESTS - ABORT

Number of abort requests received from the requester (single-phase commit protocol) and backout requests received from the coordinator (two-phase commit protocol).

Field Name: QLAPABRR

REQUESTS - REST SERVICE

The number of times that the application reported a connection or application condition from a REST service request.

Field Name: QLAPNREST

REQUESTS - PROFILE SET SPECIAL REGISTERS

The number of times that the application reported a connection or application condition from setting a special register through a profile.

Field Name: QLAPNSSR

REQUESTS - PROFILE SET GLOBAL VARIABLES

The number of times that the application reported a connection or application condition from setting a global variable through a profile.

Field Name: QLAPNSGV

DBAT NOT POOLED - WITH HOLD CURSOR NOT CLOSED

The number of times that the application used a cursor that was defined as WITH HOLD, and was not closed. That condition prevented Db2 from pooling DBATs.

Field Name: QLAPHCRSR

DBAT NOT POOLED - DGTT NOT DROPPED

The number of times that the application did not drop a declared temporary table. That condition prevented Db2 from pooling DBATs.

Field Name: QLAPDGTT

DBAT NOT POOLED - KEEPDYNAMIC PACKAGES USED

The number of times that the application used a KEEPDYNAMIC package. That condition prevented Db2 from pooling DBATs.

Field Name: QLAPKPDYN

DBAT NOT POOLED - HIGH-PERF DBAT USED

The number of times that the application used a high-performance DBAT. That condition prevented Db2 from pooling DBATs.

Field Name: QLAPHIPRF

DBAT NOT POOLED - HELD LOB LOCATOR EXIST

The number of times that the application had a held LOB locator. That condition prevented Db2 from pooling DBATs.

Field Name: QLAPHLOBLOC

DBAT NOT POOLED - STORED PROCEDURE COMMIT

The number of times that a commit was issued in a stored procedure. That condition prevented Db2 from pooling DBATs.

Field Name: QLAPSPCMT

THREADS - QUEUED(PROFILE EXC)

The number of times that a thread that was used by a connection from the application was queued because a profile exception threshold was exceeded.

Field Name: QLAPNTHDPQ

THREADS - TERMINATED(PROFILE EXC)

The number of times that a thread that was used by a connection from the application was terminated because a profile exception threshold was exceeded.

Field Name: QLAPNTHDPT

THREADS - ABENDED

The number of times that a thread that was used by a connection from the application abended.

Field Name: QLAPNTHDA

THREADS - CANCELED

The number of times that a thread that was used by a connection from the application was canceled.

Field Name: QLAPNTHDC

SERVER THREADS - ACTIVE

The current number of active threads for the application.

Field Name: QLAPNTHD

SERVER THREADS - INTERVAL HWM

For a statistics trace, this is the highest number of active threads during the current statistics interval. For a READS request, this is the highest number of active threads since DDF was started.

Field Name: QLAPHTHD

SERVER THREADS - QUEUED(MAXDBAT)

The number of threads that were queued because the MAXDBAT subsystem parameter value was exceeded.

Field Name: QLAPTHDTM

SERVER THREADS - TERMINATED

Sum of all terminated SERVER THREADS

Field Name: SQLAPTOT

SERVER THREADS - TERMINATED - IDTHTOIN EXCEEDED

the number of threads that were terminated because the IDTHTOIN subsystem parameter value was exceeded.

Field Name: QLAPTHDTI

SERVER THREADS - TERMINATED - CANCELED

The number of threads that were terminated because the CANCEL THREAD command was issued.

Field Name: QLAPTHDTC

SERVER THREADS - TERMINATED - IDLE THD PROF

The number of threads that were terminated because a profile exception condition for idle threads was exceeded.

Field Name: QLAPTHDTR

SERVER THREADS - TERMINATED - KEEP DYNAMIC REFRESH IDLE

The number of threads that were terminated because the threads were running under KEEPDYNAMIC refresh rules, and the idle time exceeded the idle time limit.

Field Name: QLAPTHDTK

SERVER THREADS - TERMINATED - KEEP DYNAMIC REFRESH USE

the number of threads that were terminated because the threads were running under KEEPDYNAMIC refresh rules, and the time that the threads were in use exceeded the in-use time limit.

Field Name: QLAPTHDTF

SERVER THREADS - TERMINATED - NETWORK

The number of threads that were terminated due to network termination.

Field Name: QLAPTHDTN