DB2 Performance Expert for Multiplatforms V2.2

An IBM Redbooks publication

Published 23 March 2006

cover image

ISBN-10: 0738496413
ISBN-13: 9780738496412
IBM Form #: SG24-6470-01
(630 pages)

More options

Rating

Authors: Whei-Jen Chen, Ute Baumbach, Marcia Miskimen, Werner Wicke

Abstract

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

Follow IBM Redbooks

Follow IBM Redbooks