Chapter 10. Performance Monitoring and Tuning
Planning
DB2 Architecture Overview
Database Monitoring
SQL Monitoring
Tuning Buffer Pool and System Parameters
Problem Determination
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 information that is input ...
Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide 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.
