Statement Information Workspace

The Statement Information workspace provides information about the SQL statement that was last performed by the Database Connection Services (DCS) application.

It enables you to measure the throughput between the client application, the DB2 Connect gateway, and the host database and to measure the times required for processing an SQL statement.

This workspace is comprised of the following views:

Application - Network (bar chart)

Shows the number of data transmissions between the DB2 Connect gateway and the host database and the number of bytes sent between the client, the DB2 Connect gateway, and the host database.

Thread/Application ID (table view)

Identifies the thread and the DCS application.

Statement Information (table view)

Provides information about the SQL statement that was last performed by the DCS application.

Time (table view)

Shows the times required for processing an SQL statement.

Network Statistics (table view)

Shows the number of bytes exchanged between the client application, the DB2 Connect gateway, and the host database.

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