Overall Transaction Data Workspace

The Overall Transaction Data workspace provides information about the Database Connection Services (DCS) application at the transaction level.

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 application, the DB2 Connect gateway, and the host database. This view enables you to measure the throughput between the client and the DB2 Connect gateway and between the DB2 Connect gateway and the host database.

Application - SQL Statement (bar chart)

Shows the number of SQL, SQL COMMIT, and SQL ROLLBACK statements that have been attempted and the number of SQL statements that have been attempted but have failed. This view enables you to measure the database activity for the DCS application.

Thread/Application ID (table view)

Identifies the thread and the DCS application.

Last Reset and Connect Timestamp (table view)

Shows when the monitor counters were reset for the application issuing the GET SNAPSHOT and when the first connection to the host database was initiated from the DB2 Connect gateway.

Network & Times (table view)

Provides details about the throughput, and the times for data transmissions, between the client application, the DB2 Connect gateway, and the host database.

Unit of Work (table view)

Provides details about the SQL statements and units of work performed.

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