DB2 Performance Monitor

The architecture of DB2 Performance Monitor comprised several key components: the Data Collector, the Reporting Facility, and the Data Repository. The Data Collector was responsible for gathering performance metrics from the DB2 subsystem. It collected data related to various aspects of DB2 performance, such as SQL statement execution, buffer pool activity, and lock contention.

The Reporting Facility processed the collected data and generated reports. These reports provided insights into the performance of the DB2 database, identifying bottlenecks and areas for optimization. The Data Repository served as the storage mechanism for the performance data.

It stored the collected metrics, allowing for historical analysis and trend identification. The tool used configuration files to define monitoring parameters. These files specified the types of data to collect, the frequency of collection, and the reporting options.

The tool did not expose any APIs for external integration. Communication between components used TCP/IP. The administrative interface was primarily a batch interface, using JCL to control the data collection and reporting processes.

User management was handled through the z/OS security system. The tool did not offer specific encryption or audit logging capabilities. Compared to IBM Db2 Performance Expert, it lacked expert analysis and buffer pool monitoring.