- Web Load Testing DB2 Monitoring

DB2 Database Monitoring

These monitors collect the main performance statistics for DB2 database servers. The data collected will help you evaluate your database's performance during the load test and pinpoint any problems related either to the application's development or to the various server parameter settings.

An application server's default settings for database access, and the default settings of the databases themselves (connection pools, dedicated memory allocation, table indexation etc.), are not always suited to the application itself and often need to be adjusted. The load test, with the DB2 server monitoring, allows you to tweak these settings and observe any subsequent improvement or deterioration in performance.

As monitoring is carried out non-intrusively; no special configuration is required for the server.

Supported versions:8.1 and later.

Performance Counters

The monitors are sorted by category: connections, catalog cache, IO requests, command rates, tables memory, pool, joins etc...

The monitor categories are:

• Connections
• Catalog Cache
• IO Requests
• Command Rates
• Tables
• Memory
• Pool
• Hash Joins
• Misc.