4.6. Monitoring Tools

As a database administrator, it is important to have a good understanding of your database environment. Some of the things you need to know are the kinds of activities that are happening on the system, the database workload, and memory usage. The Monitoring tools watch the database based on the criteria you provide and generate reports.

The graphical Monitoring tools consist of the Activity Monitor, Event Analyzer, Health Center, Indoubt Transaction manager, and the Memory Visualizer. In addition, DB2 Version 8.2 introduces a new command line Monitoring tool called db2pd.

4.6.1. The Activity Monitor

The Activity Monitor helps ...

Get Understanding DB2®: Learning Visually with Examples now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.