O'Reilly logo

DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition by Paul C. Zikopoulos, George Baklarz

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 14. Monitoring and Tuning

• PLANNING

• DB2 ARCHITECTURE OVERVIEW

• DATABASE MONITORING

• SQL MONITORING

• TUNING CONFIGURATION PARAMETERS

• PROBLEM DETERMINATION

• SELF-TUNING MEMORY MANAGER

Understanding the performance of the DB2 database management system, its databases, and active applications in a dynamic environment requires monitoring. This means that a database administrator should gather information regarding the usage of the database. An application programmer may also require SQL statement execution information. Gathering database information using DB2's monitoring facilities and information regarding SQL statement processing will be discussed.

In this chapter, the various DB2 facilities for the monitoring and gathering of ...

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