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 ...
Get DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
