IFCID 411 - Remote Application Statistics
This topic shows detailed information about Record Trace - IFCID 411 - Remote
Application Statistics
.
IFCID 0411 records detailed statistics about the remote applications that connect to a local Db2 subsystem using the DRDA protocol. This record is written when Statistics trace class 10 is on. The REMOTE APPLICATION STATISTICS section is shown for each application connected to the Db2 subsystem remotely.
Record Trace - IFCID 411 - Remote Application Statistics
The field labels shown in the following sample layout of Record Trace - IFCID 411 -
Remote Application Statistics
are described in the following section.
REMOTE APPLICATIONS STATISTICS
SECTIONS IN RECORD..........: 50
ANOTHER IFCID 411 FOLLOWS...: YES
APPLICATION NAME.: JAVAAPPLICATION#10NAME
GENERAL INFORMATION APPLICATION THREADS QUANTITY
--------------------------------------------------- ---------------------------------------------------
QLAP VERSION 000001 QUEUED(PROFILE EXC) 0
PRODUCT ID JCC04270 TERMINATED(PROFILE EXC) 0
PRODUCT LEVEL 25 ABENDED 0
CANCELED 0
REQUESTS QUANTITY SERVER THREADS QUANTITY
--------------------------------------------------- ---------------------------------------------------
COMMIT 1 ACTIVE 0
ABORT 0 INTERVAL HWM 1
REST SERVICE 0 QUEUED(MAXDBAT) 0
PROFILE SET SPECIAL REGISTERS 0 TERMINATED
PROFILE SET GLOBAL VARIABLES 0 IDTHTOIN EXCEEDED 0
CANCELED 0
DBAT NOT POOLED(REASON) QUANTITY IDLE THD PROF 0
--------------------------------------------------- KEEP DYNAMIC REFRESH IDLE 0
WITH HOLD CURSOR NOT CLOSED 0 KEEP DYNAMIC REFRESH USE 0
DGTT NOT DROPPED 0 NETWORK 0
KEEPDYNAMIC PACKAGES USED 0
HIGH-PERF DBAT USED 0
HELD LOB LOCATOR EXIST 0
STORED PROCEDURE COMMIT 0
- SECTIONS IN RECORD
-
Number of QLAP sections in the record.
Field Name: QW0411NO
- ANOTHER IFCID 411 FOLLOWS
-
This bitcounter indicates if another IFCID 411 is shown in the Db2 trace data.
Field Name: QW0411FL
- 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
- GENERAL - QLAP VERSION
Version of the QLAP record.
'000001' : The QLAP section contains fields QLAPAPPN_OFF to QLAPTHDTN.
Field Name: QLAPVRSN
- GENERAL - PRODUCT ID
-
The product ID of the remote location from which the application connects. See QLAPPRLV for the product level.
Field Name: QLAPPRID
- GENERAL - 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
- APPLICATION 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
- APPLICATION 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
- APPLICATION THREADS - ABENDED
-
The number of times that a thread that was used by a connection from the application abended.
Field Name: QLAPNTHDA
- APPLICATION 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 - 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