DB2 Performance Expert (PE) for Multiplatforms V2.2 is a workstation-based performance analysis and tuning tool for managing a heterogeneous mix of DB2 systems with a single end-user interface. DB2 PE simplifies DB2 performance management by providing you with the ability to monitor applications, system statistics, and system parameters using a single tool.
This IBM Redbooks publication provides an overview of the architecture of DB2 Performance Expert. We highlight key considerations in planning DB2 PE V2.2 for your environment and provide a step-by-step installation and configuration guide
We discuss, in detail, the DB2 PE V2.2 functions and features. Recommendations and tips for DB2 performance tuning are also introduced.
Finally, we discuss some of the commonly encountered problems faced by a DBA when managing a DB2 environment, and describe how the tool can be used to diagnose and resolve these performance problems.
Table of contents
Chapter 1. Introduction
Chapter 2. Planning and installation
Chapter 3. Configuration and verification
Chapter 4. Features and functions - online and short-term monitoring
Chapter 5. Features and functions - long-term monitoring
Chapter 6. Scenarios
Appendix A. Rules of Thumb definition samples
Appendix B. Monitoring CM databases with Performance Expert
Appendix C. DB2 Performance Expert For Business Intelligence