Distributed Thread SQL Statistics Workspace

The Distributed Thread SQL Statistics workspace provides distributed SQL statistics for a remote DB2 location with which the distributed (DDF) thread has communicated, as a requester or a server.

This workspace is comprised of the following views:

Thread ID (table view)

Identifies the thread.

Distributed VTAM APPC Conversations (table view)

Shows the VTAM APPC conversations data of the thread if the thread is connected through VTAM APPC.

Distributed TCP/IP Data (table view)

Shows the TCP/IP data of the thread if the thread is connected through TCP/IP.

Distributed SQL Statistics (table view)

Shows SQL-related statistics for the selected remote DB2 location with which the thread has communicated, as a requester or a server.

Send & Receive (table view)

Shows send and receive data for the selected remote DB2 location with which the thread has communicated, as either a requester or a server.

2-Phase Commit: Send & Receive (table view)

Shows two-phase-commit-related send and receive data for the selected remote DB2 location with which the thread has communicated, as either a requester or a server.

Based on the information that this workspace provides, you can recommend changes, set up situations, and verify that your recommended changes improve system performance.