Skip to main content

Performance Management: Using IBM InfoSphere Optim Performance Manager and Query Workload Tuner

An IBM Redbooks publication

thumbnail 

Published on 16 October 2013, updated 27 November 2013

  1. .EPUB (10.3 MB)
  2. .PDF (11.6 MB)

Apple BooksGoogle Play BooksRead in Google Books Order hardcopy
Share this page:   

ISBN-10: 0738438456
ISBN-13: 9780738438450
IBM Form #: SG24-8111-00


Authors: Chuck Ballard, Ute Baumbach, Holly Hayes, Marcia Miskimen, Lakshmi Palaniappan, Marichu Scanlon and Yong Hua Zeng

    menu icon

    Abstract

    This IBM® Redbooks® publication describes the architecture and components of IBM InfoSphere® Optim™ Performance Manager Extended Edition. Intended for DBAs and those involved in systems performance, it provides information for installation, configuration, and deployment. InfoSphere Optim Performance Manager delivers a new paradigm used to monitor and manage database and database application performance issues. It describes product dashboards and reports and provides scenarios for how they can be used to identify, diagnose, prevent, and resolve database performance problems.

    IBM InfoSphere Optim Query Workload Tuner facilitates query and query workload analysis and provides expert recommendations for improving query and query workload performance. Use InfoSphere Optim Performance Manager to identify slow running queries, top CPU consumers, or query workloads needing performance improvements and seamlessly transfer them to InfoSphere Optim Query Workload Tuner for analysis and recommendations. This is done using query formatting annotated with relevant statistics, access plan graphical or hierarchical views, and access plan analysis. It further provides recommendations for improving query structure, statistics collection, and indexes including generated command syntax and rationale for the recommendations.

    Table of Contents

    Part 1. Strategy for performance management

    Chapter 1. Guided approach to performance management

    Chapter 2. Planning your InfoSphere Optim Performance Manager deployment

    Chapter 3. Installing and configuring Optim performance management tools

    Part 2. Using IBM products to manage performance

    Chapter 4. Getting to know InfoSphere Optim Performance Manager

    Chapter 5. Getting to know InfoSphere Optim Query Workload Tuner

    Chapter 6. Finding and fixing database level bottlenecks

    Part 3. Performance management in a DB2 Distributed Environment

    Chapter 7. Performance management: Distributed DB2 environments

    Part 4. Specific topics for DB2 performance management

    Chapter 8. Implementing workload management

    Chapter 9. Monitoring packaged database application systems

    Appendix A. Performance management differences: DB2 V9.7 or later and DB2 V9.5 databases

    Appendix B. Additional material

     

    Others who read this also read