IFCID 412 - Remote User Statistics
This topic shows detailed information about Record Trace - IFCID 412 - Remote User
Statistics
.
IFCID 0412 records detailed statistics about the remote user IDs that connect to a local Db2 subsystem using the DRDA protocol. This record is written when Statistics trace class 11 is on. The REMOTE USER STATISTICS section is shown for each user ID that has connected to the Db2 subsystem remotely.
Record Trace - IFCID 412 - Remote User Statistics
The field labels shown in the following sample layout of Record Trace - IFCID 412 - Remote User Statistics
are described in the following section.
REMOTE USER STATISTICS
SECTIONS IN RECORD..........: 50
ANOTHER IFCID 412 FOLLOWS...: YES
USER NAME.: USERIDTS5785A#10LONGIDS
GENERAL INFORMATION APPLICATION THREADS QUANTITY
--------------------------------------------------- ---------------------------------------------------
QLAU 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 QLAU sections in the record.
Field Name: QW0412NO
- ANOTHER IFCID 411 FOLLOWS
-
This bitcounter indicates if another IFCID 412 is shown in the Db2 trace data.
Field Name: QW0412FL
- USER NAME
-
The name of the client user ID under which the connection from the remote application to the local site is established. This field contains the value of the CURRENT CLIENT_USERID special register at the time of the initial connection, converted to uppercase. See the CURRENT CLIENT_USERID topic in IBM documentation for more information.
Field Name: QLAUUSRI
- GENERAL - QLAU VERSION
Version of the QLAU record.
'000001' : The QLAU section contains fields QLAUUSRI_OFF to QLAUTHDTN.
Field Name: QLAUVRSN
- GENERAL - PRODUCT ID
-
The product ID of the remote location from which the application connects. See QLAUPRLV for the product level.
Field Name: QLAUPRID
- GENERAL - PRODUCT LEVEL
-
Product level, if known.
Field Name: QLAUPRLV
- 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: QLAUCOMR
- REQUESTS - ABORT
-
Number of abort requests received from the requester (single-phase commit protocol) and number of backout requests received from the coordinator (two-phase commit protocol).
Field Name: QLAUABRR
- REQUESTS - REST SERVICE
-
The number of times that the application reported a connection or application condition from a REST service request.
Field Name: QLAUNREST
- REQUESTS - PROFILE SET SPECIAL REGISTERS
-
The number of times that an application run by the specified client user ID reported a connection or application condition from setting a special register through a profile.
Field Name: QLAUNSSR
- REQUESTS - PROFILE SET GLOBAL VARIABLES
-
The number of times that an application run by the specified client user ID reported a connection or application condition from setting a global variable through a profile.
Field Name: QLAUNSGV
- DBAT NOT POOLED - WITH HOLD CURSOR NOT CLOSED
-
The number of times that an application run by the specified client user ID used a cursor that was defined as WITH HOLD, and was not closed. That condition prevented Db2 form pooling dbats.
Field Name: QLAUHCRSR
- DBAT NOT POOLED - DGTT NOT DROPPED
-
The number of times that an application run by the specified client user ID did not drop a declared temporary table. That condition prevented Db2 from pooling DBATs.
Field Name: QLAUDGTT
- DBAT NOT POOLED - KEEPDYNAMIC PACKAGES USED
-
The number of times that an application run by the specified client user ID used KEEPDYNAMIC packages. That condition prevented Db2 from pooling DBATs.
Field Name: QLAUKPDYN
- DBAT NOT POOLED - HIGH-PERF DBAT USED
-
The number of times that an application run by the specified client user ID used a high-performance DBAT. That condition prevented Db2 from pooling DBATs.
Field Name: QLAUHIPRF
- DBAT NOT POOLED - HELD LOB LOCATOR EXIST
-
The number of times that an application run by the specified client user ID used a held LOB locator. That condition prevented Db2 from pooling DBATs.
Field Name: QLAUHLOBLOC
- DBAT NOT POOLED - STORED PROCEDURE COMMIT
-
The number of times that a commit was issued in a stored procedure that was called by the specified client user ID. That condition prevented Db2 from pooling DBATs.
Field Name: QLAUSPCMT
- APPLICATION THREADS - QUEUED (PROFILE EXC)
-
The number of times that a thread that was used by a connection from the application run by the specified client user ID was queued because a profile exception threshold was exceeded.
Field Name: QLAUNTHDPQ
- APPLICATION THREADS - TERMINATED (PROFILE EXC)
-
The number of times that a thread that was used by a connection from the application run by the specified client user ID terminated because a profile exception threshold was exceeded.
Field Name: QLAUNTHDPT
- APPLICATION THREADS - ABENDED
-
The number of times that a thread that was used by a connection from an application run by the specified client user ID abended.
Field Name: QLAUNTHDA
- APPLICATION THREADS - CANCELED
-
The number of times that a thread that was used by a connection from an application run by the specified client user ID was canceled.
Field Name: QLAUNTHDC
- SERVER THREADS - ACTIVE
-
The current number of active threads for the application run by the specified client user ID.
Field Name: QLAUNTHD
- 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: QLAUHTHD
- SERVER THREADS - QUEUED (MAXDBAT)
-
The number of threads associated with the specified client user ID that were queued because the MAXDBAT subsystem parameter value was exceeded.
Field Name: QLAUTHDTM
- SERVER THREADS - TERMINATED - IDTHTOIN EXCEEDED
-
The number of threads associated with the specified client user ID that were terminated because the IDTHTOIN subsystem parameter value was exceeded.
Field Name: QLAUTHDTI
- SERVER THREADS - TERMINATED - CANCELED
-
The number of threads associated with the specified client user ID that were terminated because the CANCEL THREAD command was issued.
Field Name: QLAUTHDTC
- SERVER THREADS - TERMINATED - IDLE THD PROF
-
The number of threads associated with the specified client user ID that were terminated because a profile exception condition for idle threads was exceeded.
Field Name: QLAUTHDTR
- SERVER THREADS - TERMINATED - KEEP DYNAMIC REFRESH IDLE
-
The number of threads associated with the specified client user ID that were terminated because the threads were running under KEEPDYNAMIC refresh rules, and the idle time exceeded the idle time limit.
Field Name: QLAUTHDTK
- SERVER THREADS - TERMINATED - KEEP DYNAMIC REFRESH USE
-
The number of threads associated with the specified client user ID that were terminated because the threads were running under KEEPDYNAMIC refresh rules, and the time that they were in use exceeded the in-use time limit.
Field Name: QLAUTHDTF
- SERVER THREADS - TERMINATED - NETWORK
-
The number of threads associated with the specified client user ID that were terminated due to network termination.
Field Name: QLAUTHDTN