IFCID 365 - Remote Location Statistics

The IFCID 365 record block provides detailed statistics about the remote locations with which a Db2 subsystem communicates using the DRDA protocol. This record is written when statistics trace class 7 is on. The DDF DATA BY LOCATION section is shown for each location with which the Db2 subsystem communicates.

REMOTE LOCATIONS STATISTICS

SECTIONS IN RECORD ........:                    3           ANOTHER IFCID365 FOLLOWS ..:                   NO

DDF DATA BY LOCATION
LOCATION NAME (SHORT)......: ::FFFF:10.17.40.               PRDID REMOTE LOCATION .....: JCC04240             
LOCATION NAME (LONG).......: ::FFFF:10.17.40.72                                                               
                                                                                                              
INITIATED CONNECTIONS......:                    0           DEALLOCATED CONNECTIONS....:                    0 
INITIATED FROM REMOTE SITE.:                    3                                                             
MESSAGES SENT TO REMOTE....:                   67           MESSAGES RECV FR REMOTE....:                   67 
SQL STMTS SENT TO REMOTE...:                    0           SQL STMTS RECV FR REMOTE...:                   49 
BYTES SENT TO REMOTE.......:                 8932           BYTES RECV FR REMOTE...... :                 8898 
ROWS SENT TO REMOTE........:                   12           ROWS RETRIEVED FR REMOTE...:                    0 
BLOCKS TRANSMITTED.........:                   24           BLOCKS RECEIVED............:                    0 
COMMIT REQUESTS SENT.......:                    0           COMMIT REQUESTS RECEIVED...:                   18 
ABORT REQUESTS SENT........:                    0           ABORT REQUESTS RECEIVED....:                    0 
INDOUBT THREADS............:                    0           CONN REQUESTS QUEUED.......:                    0 
REST REQUESTS..............:                 nnnn           KEEPDYNAMIC PACKAGES USED..:                 nnnn 
SET SPECIAL REGISTERS......:                 nnnn           HIGH PERFORMANCE DBATS USED:                 nnnn 
SET GLOBAL VARIABLES.......:                 nnnn           HELD LOB LOCATOR(S)........:                 nnnn 
SYSPLEX BALANCING USED.....:                 nnnn           STORED PROCEDURE COMMITS...:                 nnnn 
TLS/SSL USED...............:                 nnnn           CONDBAT REACHED............:                 nnnn 
TRUSTED CONTEXT USED.......:                 nnnn           PROFILE EXCEPTIONS.........:                 nnnn 
AES ENCRYPTION USED........:                 nnnn           MAXCONQN REACHED...........:                 nnnn 
XA GLOBAL TRANSACTION USED.:                 nnnn           MAXCONQW REACHED...........:                 nnnn 
DRDA ENCRYPTION USED.......:                 nnnn           THREADS QUEUED (PROFILE)...:                 nnnn 
UID/PWD AUTH USED..........:                 nnnn           THRDS TERMINATED (PROFILE).:                 nnnn 
KERBEROS AUTH USED.........:                 nnnn           REMOTE THREADS ABENDED.....:                 nnnn 
MULTIFACTOR AUTH USED......:                 nnnn           REMOTE THREADS CANCELLED...:                 nnnn 
CLIENT CERT AUTH USED......:                 nnnn           CONNECTIONS (SNAPSHOT).....:                 nnnn 
FAILED SEC AUTH............:                 nnnn           CONNECTIONS (HWM)..........:                 nnnn 
WITH HOLD CSR NOT CLOSED...:                 nnnn           ACTIVE THREADS (SNAPSHOT)..:                 nnnn 
DGTT NOT DROPPED...........:                 nnnn           ACTIVE THREADS (HWM).......:                 nnnn

The fields shown in this record block are described below. Db2 field names are shown in brackets next to each report field.

SECTIONS IN RECORD [QW0365NO]

The number of QLST sections that are part of this IFCID 365 record.

ANOTHER IFCID365 FOLLOWS [QW0365FL]

Indicates if another IFCID 365 is shown in the Db2 trace data.

LOCATION NAME (SHORT) [QLSTLOCN]

The name of the remote location.

PRDID REMOTE LOCATION [QLSTPRID]

The product ID and version of the remote location.

LOCATION NAME (LONG) [QLSTLOCN]

The name of the remote location.

INITIATED CONNECTIONS [QLSTCNVS]

The number of connections that were initiated from the requester location. This value is maintained at the requester location. A conversation is a specific instance TCP/IP or SNA LU 6.2 being used to transfer information between a requester and a server. A conversation is a logical connection between a requester and a server.

DEALLOCATED CONNECTIONS [QLSTCNVT]

The number of connections that were deallocated from this site to the remote site.

INITIATED FROM REMOTE SITE [QLSTCNVR]

The number of conversations that were initiated from the requester to the server location. This value is updated at the server location.

MESSAGES SENT TO REMOTE [QLSTMSGS]

The number of messages sent to the remote location. A message is a group of characters and control bit sequences transferred on a single TCP/IP or SNA API call. This value is maintained at the location where the messages originated.

MESSAGES RECV FR REMOTE [QLSTMSGR]

The number of messages received by VTAM from the remote location. This value is maintained at the location where the messages were received. More messages might be sent from the server location than are received by the requester due to the manner in which distributed SQL statements are processed internally.

SQL STMTS SENT TO REMOTE [QLSTSQLS]

The number of SQL statements sent to the remote server. This value is updated at the requester location.

SQL STMTS RECV FR REMOTE [QLSTSQLR]

The number of SQL statements received from the requester location. This value is updated at the server location.

BYTES SENT TO REMOTE [QLSTBYTS]

The number of bytes of data sent to the requester location. This value is maintained at the server location.

BYTES RECV FR REMOTE [QLSTBYTR]

The number of bytes of data received from the server location. This value is maintained at the requester location. More bytes of data might be sent from the server location than are received by the requester due to the manner in which distributed SQL statements are processed internally.

ROWS SENT TO REMOTE [QLSTROWS]

The number of data rows sent to the requester location (includes SQLDA). This value is updated at the server location.

ROWS RETRIEVED FR REMOTE [QLSTROWR]

The number of data rows received from the server location. This value is maintained at the requester location.

Note:

• This value does not include any SQLDA or SQLCA transmitted.
• Block fetch can significantly affect the number of rows sent across the network. When used with nonupdate cursors, block fetch groups as many rows as possible into the message buffer, and transmits the buffer over the network without requiring a VTAM message. Consequently, more rows of data might be sent from the server location than are received by the requester location.

  This is especially true when Db2 private protocol is used because multiple blocks can be transmitted from the server with no intervening messages from the requester.

BLOCKS TRANSMITTED [QLSTBTBF]

The number of blocks transmitted using block fetch. This value is maintained at the server location.

BLOCKS RECEIVED [QLSTBRBF]

The number of blocks received from the remote location using block fetch. This value is maintained at the requester location.

COMMIT REQUESTS SENT [QLSTCOMS]

The number of commit requests sent to the server (single-phase commit protocol) and the committed requests sent to the participant (two-phase commit protocol).

COMMIT REQUESTS RECEIVED [QLSTCOMR]

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

ABORT REQUESTS SENT [QLSTABRS]

The number of abort requests sent to the server (single-phase commit protocol) and the number of backout requests sent to the participant (two-phase commit protocol).

ABORT REQUESTS RECEIVED [QLSTABRR]

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

INDOUBT THREADS [QLSTINDT]

The number of threads that became indoubt with the remote location as the coordinator.

CONN REQUESTS QUEUED [QLSTCNVQ]

The number of conversation requests queued by DDF waiting for allocation (requester) divided by the number of conversation requests queued waiting for a DBAT when MAXDBAT reached.

REST REQUESTS [QLSTNREST]

The number of times that a connection from the remote site invoked a rest service.

KEEPDYNAMIC PACKAGES USED [QLSTKPDYN]

The number of times the usage of keepdynamic packages prevented thread pooling.

SET SPECIAL REGISTERS [QLSTNSSR]

The number of times that a connection from the remote site caused a system monitoring profile to set special registers.

HIGH PERFORMANCE DBATS USED [QLSTHIPRF]

The number of times the usage of high performance DBATs prevented thread pooling.

SET GLOBAL VARIABLES [QLSTNSGV]

The number of times that a connection from the remote site caused a system monitoring profile to set global variables.

HELD LOB LOCATOR(S) [QLSTHLOBLOC]

The number of times the existence of active held lob locators prevented thread pooling.

SYSPLEX BALANCING USED [QLSTNWLB]

The number of connections from the remote site using sysplex workload balancing.

STORED PROCEDURE COMMITS [QLSTSPCMT]

The number of times a stored procedure issued commit prevented thread pooling.

TLS/SSL USED [QLSTNTLS]

The number of connections from the remote site configured with SSL and AT/TLS support.

CONDBAT REACHED [QLSTCNVTC]

The number of connections from the remote site that were terminated due to CONDBAT being reached.

TRUSTED CONTEXT USED [QLSTNTRS]

The number of connections from the remote site under control of a trusted context.

PROFILE EXCEPTIONS [QLSTCNVTP]

The number of connections from the remote site that were terminated due to system monitoring profile exception.

AES ENCRYPTION USED [QLSTNAES]

The number of connections from the remote site using AES encryption.

MAXCONQN REACHED [QLSTCNVTQN]

The number of connections from the remote site that were terminated due to MAXCONQN being reached.

XA GLOBAL TRANSACTION USED [QLSTNXA]

The number of connections from the remote site under control of an XA global transaction.

MAXCONQW REACHED [QLSTCNVTQW]

The number of connections from the remote site that were terminated due to MAXCONQW being reached.

DRDA ENCRYPTION USED [QLSTNENC]

The number of connections from the remote site using DRDA data encryption.

THREADS QUEUED (PROFILE) [QLSTNTHDPQ]

The number of times threads used by connections from the remote site were queued due to a system monitoring profile exception.

UID/PWD AUTH USED [QLSTNPWD]

The number of connections from the remote site using userid or password authentication.

THRDS TERMINATED (PROFILE) [QLSTNTHDPT]

The number of times threads used by connections from the remote site were terminated due to a system monitoring profile exception.

KERBEROS AUTH USED [QLSTNKER]

The number of connections from the remote site using kerberos authentication.

REMOTE THREADS ABENDED [QLSTNTHDA]

The number of times threads used by connections from the remote site abended.

MULTIFACTOR AUTH USED [QLSTNMFA]

The number of connections from the remote site using multifactor authentication.

REMOTE THREADS CANCELLED [QLSTNTHDC]

The number of times threads used by connections from the remote site were canceled.

CLIENT CERT AUTH USED [QLSTNCCA]

The number of connections from the remote site using client certificate authentication.

CONNECTIONS (SNAPSHOT) [QLSTNCNV]

The current number of active connections from this location.

FAILED SEC AUTH [QLSTFSEC]

The number of times that a connection from the remote site had security authentication failures.

CONNECTIONS (HWM) [QLSTHCNV]

The highest number of active connections from this location since the last statistics trace interval for a statistics trace request. For a READS request, this value is the highest number of active connections from this location since DDF was started.

WITH HOLD CSR NOT CLOSED [QLSTHCRSR]

The number of times that cursors defined with HOLD prevented thread pooling.

ACTIVE THREADS (SNAPSHOT) [QLSTNTHD]

The current number of active threads in use by this location.

DGTT NOT DROPPED [QLSTDGTT]

The number of times the existence of active declared global temp tables prevented thread pooling.

ACTIVE THREADS (HWM) [QLSTHTHD]

The highest number of active threads in use by this location since the last statistics trace interval for a statistics trace request. For a READS request, this value is the highest number of active threads in use by this location since DDF was started.