O'Reilly logo

DB2 9 for Developers by Philip K. Gunning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Monitoring

In this chapter, we cover DB2 monitoring, introducing the concepts of online monitoring and exception-based monitoring and then addressing in detail the DB2 9 facilities used to conduct these two essential activities: snapshot monitoring, the DB2 Health Center and Health Monitor, Memory Visualizer, Activity Monitor, Memory Tracker, the db2pd utility, and event monitoring. We conclude the chapter with a summary of DB2 9 built-in monitoring facilities and tools and look at some examples of how to use them to monitor DB2 database performance.

Monitoring

There are basically two types of monitoring that we as DBAs need to use: online (or real-time) monitoring and exception-based (24x7) monitoring. The DB2 base product contains ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required