Part IV. DB2 Performance Monitoring

After you have established a DB2 environment and installed application systems that access that environment, it is imperative that the environment be monitored regularly to ensure optimal performance. Usually a database administrator, a performance analyst, or a system administrator performs the job of monitoring DB2 performance. Sometimes, each of these roles is required to monitor and tune different aspects of DB2 performance.

Many factors contribute to the performance level achieved by DB2 applications. Unless an orderly and consistent approach to DB2 performance monitoring is implemented, an effective approach to tuning cannot be achieved and the performance of DB2 applications might fluctuate wildly from ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.