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.

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