Skip to main content

DB2 Performance Expert for Multiplatforms V2.2

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

thumbnail 

Published on 23 March 2006

  1. .PDF (10.4 MB)


Share this page:   

ISBN-10: 0738496413
ISBN-13: 9780738496412
IBM Form #: SG24-6470-01


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

    menu icon

    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

     

    Others who read this also read