IFCID 365 - Remote Location Statistics

This topic shows detailed information about Record Trace - IFCID 365 - Remote Location Statistics

IFCID 0365 records 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.

Recommendation: Generate Performance Database (PDB) and CSV data for IFCID 365 using Statistics reports, not Record Trace reports. Statistics reports provide deltas, making the data easier to process compared to the aggregated values from Record Trace reports.

Record Trace - IFCID 365 - Remote Location Statistics

The field labels shown in the following sample layout of Record Trace - IFCID 365 - Remote Location Statistics are described in the following section.



                                            REMOTE LOCATIONS STATISTICS

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

                                                DDF DATA BY LOCATION

LOCATION NAME (SHORT)......: ::FFFF:10.15.60.               PRDID REMOTE LOCATION .....: JCC03720
LOCATION NAME (LONG).......: ::FFFF:10.15.60.28

INITIATED CONNECTIONS......:                    0           DEALLOCATED CONNECTIONS....:                    0
INITIATED FROM REMOTE SITE.:                    2
MESSAGES SENT TO REMOTE....:                   29           MESSAGES RECV FR REMOTE....:                   29
SQL STMTS SENT TO REMOTE...:                    0           SQL STMTS RECV FR REMOTE...:                   19
BYTES SENT TO REMOTE.......:                35584           BYTES RECV FR REMOTE...... :                 3772
ROWS SENT TO REMOTE........:                   21           ROWS RETRIEVED FR REMOTE...:                    0
BLOCKS TRANSMITTED.........:                   12           BLOCKS RECEIVED............:                    0
COMMIT REQUESTS SENT.......:                    0           COMMIT REQUESTS RECEIVED...:                    8
ABORT REQUESTS SENT........:                    0           ABORT REQUESTS RECEIVED....:                    0
INDOUBT THREADS............:                    0           CONN REQUESTS QUEUED.......:                    0
REST REQUESTS..............:                    0           KEEPDYNAMIC PACKAGES USED..:                    0
SET SPECIAL REGISTERS......:                    0           HIGH PERFORMANCE DBATS USED:                    0
SET GLOBAL VARIABLES.......:                    0           HELD LOB LOCATOR(S)........:                    0
SYSPLEX BALANCING USED.....:                    0           STORED PROCEDURE COMMITS...:                    0
TLS/SSL USED...............:                    0           CONDBAT REACHED............:                    0
TRUSTED CONTEXT USED.......:                    0           PROFILE EXCEPTIONS.........:                    0
AES ENCRYPTION USED........:                    0           MAXCONQN REACHED...........:                    0
XA GLOBAL TRANSACTION USED.:                    0           MAXCONQW REACHED...........:                    0
DRDA ENCRYPTION USED.......:                    0           THREADS QUEUED (PROFILE)...:                    0
UID/PWD AUTH USED..........:                    2           THRDS TERMINATED (PROFILE).:                    0
KERBEROS AUTH USED.........:                    0           REMOTE THREADS ABENDED.....:                    0
CLIENT CERT AUTH USED......:                    0           CONNECTIONS (SNAPSHOT).....:                    0
FAILED SEC AUTH............:                    0           CONNECTIONS (INT. HWM).....:                    2
WITH HOLD CSR NOT CLOSED...:                    0           ACTIVE THREADS (SNAPSHOT)..:                    0
DGTT NOT DROPPED...........:                    0           ACTIVE THREADS (INT. HWM)..:                    1
MULTIFACTOR AUTH USED......:                    0           REMOTE THREADS CANCELLED...:                    0
THRDS TERMINATED(POOLINAC).:                    0           THRDS TERMINATED(CONN LOSS):                    0
AUTHENTICATION TOKEN USED..:                    1

SECTIONS IN RECORD

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

Field Name: QW0365NO

ANOTHER IFCID365 FOLLOWS

This bitcounter indicates if another IFCID 365 is shown in the Db2 trace data.

Field Name: QW0365FL

LOCATION NAME (SHORT)

The name of the remote location.

Field Name: QLSTLOCN

LOCATION NAME (LONG)

The name of the remote location.

Field Name: QLSTLOCN

INITIATED CONNECTIONS

The number of connections that were initiated from the requester site to the remote site. This value is maintained at the requester site.

A connection is a specific instance of using TCP/IP or SNA LU 6.2 to transfer information between a requester and a server. It is a logical connection between a requester and a server.

Field Name: Db2 field QLSTCNVS

INITIATED FROM REMOTE SITE

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

Field Name: Db2 field QLSTCNVR

MESSAGES SENT TO REMOTE

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.

Field Name: Db2 field QLSTMSGS

SQL STMTS SENT TO REMOTE

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

Field Name: Db2 field QLSTSQLS

BYTES SENT TO REMOTE

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

Field Name: Db2 field QLSTBYTS

ROWS SENT TO REMOTE

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

Field Name: Db2 from field QLSTROWS

BLOCKS TRANSMITTED

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

Field Name: Db2 field QLSTBTBF

COMMIT REQUESTS SENT

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).

Field Name: Db2 FIELD QLSTCOMS

ABORT REQUESTS SENT

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

Field Name: Db2 FIELD QLSTABRS

INDOUBT THREADS

The number of threads that became indoubt with the remote location as the coordinator (two-phase commit operations only). A large value might indicate network problems.

Field Name: Db2 field QLSTINDT

REST REQUESTS

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

Field Name: QLSTNREST

SET SPECIAL REGISTERS

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

Field Name: QLSTNSSR

SET GLOBAL VARIABLES

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

Field Name: QLSTNSGV

SYSPLEX BALANCING USED

Number of connections from the remote site using sysplex workload balancing.

Field Name: QLSTNWLB

TLS/SSL USED

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

Field Name: QLSTNTLS

TRUSTED CONTEXT USED

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

Field Name: QLSTNTRS

AES ENCRYPTION USED

Number of connections from the remote site using AES encryption.

Field Name: QLSTNAES

XA GLOBAL TRANSACTION USED

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

Field Name: QLSTNXA

DRDA ENCRYPTION USED

Number of connections from the remote site using DRDA data encryption.

Field Name: QLSTNENC

UID/PWD AUTH USED

Number of connections from the remote site using userid and/or password authentication.

Field Name: QLSTNPWD

KERBEROS AUTH USED

Number of connections from the remote site using kerberos authentication.

Field Name: QLSTNKER

MULTIFACTOR AUTH USED

Number of connections from the remote site using multifactor authentication.

Field Name:QLSTNMFA

CLIENT CERT AUTH USED

Number of connections from the remote site using client certificate authentication.

Field Name: QLSTNCCA

FAILED SEC AUTH

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

Field Name: QLSTFSEC

WITH HOLD CSR NOT CLOSED

Number of times that cursors defined with HOLD prevented thread pooling.

Field Name: QLSTHCRSR

DGTT NOT DROPPED

Number of times where the existence of active declared global temp tables prevented thread pooling.

Field Name: QLSTDGTT

MULTIFACTOR AUTH USED

Number of connections from the remote site using multifactor authentication.

Field Name: QLSTNMFA

THRDS TERMINATED (POOLINAC)

Number of times that threads used by connections from remote site were terminated after high performance DBAT remained in pool longer than POOLINAC (or 120 seconds if POOLINAC=0).

Field Name: QLSTNTPLH

PRDID REMOTE LOCATION

The product ID and version of the remote location.

Field Name: QLSTPRID

DEALLOCATED CONNECTIONS

The number of connections that were deallocated from this site to the remote site if Db2 was requester. Otherwise, the number of connections received by Db2 from the remote site which were terminated as incomplete.

Field Name: QLSTCNVT

MESSAGES RECV FR REMOTE

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.

Field Name: Db2 field QLSTMSGR

SQL STMTS RECV FR REMOTE

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

Field Name: Db2 field QLSTSQLR

BYTES RECV FR REMOTE

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.

Field Name: Db2 field QLSTBYTR

ROWS RETRIEVED FR REMOTE

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

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.

Field Name: Db2 FIELD QLSTROWR

BLOCKS RECEIVED

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

Field Name: Db2 field QLSTBRBF

COMMIT REQUESTS RECEIVED

The 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: Db2 FIELD QLSTCOMR

ABORT REQUESTS RECEIVED

The 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: Db2 FIELD QLSTABRR

CONN REQUESTS QUEUED

The number of connection requests queued by the distributed data facility that were waiting for allocation or waiting for a DBAT because MAXDBAT was exceeded. This value is maintained at the requester location.

Note:

When this value is high, increase the limit for the number of connections.

Field Name: Db2 field QLSTCNVQ

KEEPDYNAMIC PACKAGES USED

Number of times where the usage of keepdynamic packages prevented thread pooling.

Field Name: QLSTKPDYN

HIGH PERFORMANCE DBATS USED

Number of times where the usage of high performance DBATs prevented thread pooling.

Field Name: QLSTHIPRF

HELD LOB LOCATOR(S)

Number of times where the existence of active held lob locators prevented thread pooling.

Field Name: QLSTHLOBLOC

STORED PROCEDURE COMMITS

Number of times where a stored procedure issued commit prevented thread pooling.

Field Name: QLSTSPCMT

CONDBAT REACHED

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

Field Name: QLSTCNVTC

PROFILE EXCEPTIONS

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

Field Name: QLSTCNVTP

MAXCONQN REACHED

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

Field Name: QLSTCNVTQN

MAXCONQW REACHED

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

Field Name: QLSTCNVTQW

THREADS QUEUED (PROFILE)

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

Field Name: QLSTNTHDPQ

THRDS TERMINATED (PROFILE)

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

Field Name: QLSTNTHDPT

REMOTE THREADS ABENDED

Number of times where threads used by connections from the remote site abended.

Field Name: QLSTNTHDA

REMOTE THREADS CANCELLED

Number of times where threads used by connections from the remote site were canceled.

Field Name:QLSTNTHDC

CONNECTIONS (SNAPSHOT)

Current number of active connections from this location.

Field Name: QLSTNCNV

CONNECTIONS (INT. HWM)

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

Field Name: QLSTHCNV

ACTIVE THREADS (SNAPSHOT)

Current number of active threads in use by this location.

Field Name: QLSTNTHD

ACTIVE THREADS (INT. HWM)

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, highest number of active threads in use by this location since DDF was started.

Field Name: QLSTHTHD

THRDS TERMINATED (POOLINAC)

Number of times that threads used by connections from remote site were terminated after high performance DBAT remained in pool longer than POOLINAC (or 120 seconds if POOLINAC=0).

Field Name: QLSTNTPLH

THRDS TERMINATED (CONN LOSS)

Number of times that threads used by connections from the remote site were terminated after TCP socket closed due to connection loss.

Field Name: QLSTNTILS

AUTHENTICATION TOKEN USED

Number of connections from the remote site that used an authentication token(JWT/IDT).

Field Name: QLSTNATK