• 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 ...