Package Statistics Workspace

The Package Statistics workspace provides information about the size of the data exchanged between the DB2 Connect gateway and the host database and about the network time required.

It enables you to measure the throughput between the host database and the DB2 Connect gateway and gives you a better idea of the database activity and network traffic at the application level.

This workspace is comprised of the following views:

Thread/Application ID (table view)

Identifies the thread and the Database Connection Services (DCS) application.

Outbound Data (table view)

Shows the number of bytes exchanged between the host database and the DB2 Connect gateway during the processing of statements.

Network Time (table view)

Shows how many statements required which network time. The network time is the difference between the host response time and the elapsed execution time for a statement.

Data Sent (table view)

Shows how many packages of a certain size were sent from the DB2 Connect gateway to the host database.

Data Received (table view)

Shows many packages of a certain size were sent from the host database to the DB2 Connect gateway.

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