Remote User Statistics
This topic shows detailed information about Statistics - 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.
Statistics - Remote User Statistics
The field labels shown in the following sample layout of Statistics - Remote User
Statistics
are described in the following section.
REMOTE USER STATISTICS VALUE REMOTE USER STATISTICS QUANTITY
---------------------- ------------------------------------------------------ ------------------------------- --------
USER NAME LPUSR1ST001 REQUESTS
PRODUCT ID DSN12099 COMMIT 0.00
PRODUCT LEVEL V12R1M509 ABORT 0.00
REST SERVICE 0.00
PROFILE SET SPECIAL REGISTERS 0.00
PROFILE SET GLOBAL VARIABLES 0.00
REMOTE USER STATISTICS QUANTITY REMOTE USER STATISTICS QUANTITY REMOTE USER 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
- 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
- PRODUCT ID
-
The product ID of the remote location from which the application connects. See QLAUPRLV for the product level.
Field Name: QLAUPRID
- 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
- 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
- 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
- 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
- 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
-
Sum of all terminated SERVER THREADS.
Field Name: SQLAUTOT
- 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