Book description
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.
Please note that the additional material referenced in the text is not available from IBM.
Table of contents
- Front cover
- Notices
- Preface
- Part 1 Strategy for performance management
-
Chapter 1. Guided approach to performance management
- 1.1 Overall IBM InfoSphere approach
-
1.2 What is new in the products
- 1.2.1 InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows V5.1
- 1.2.2 InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows V5.2
- 1.2.3 InfoSphere Optim Query Workload Tuner for DB2 Linux, UNIX, and Windows
- 1.2.4 IBM InfoSphere Optim Configuration Manager for DB2 for Linux, UNIX, and Windows
- 1.2.5 IBM InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows V3.2
- 1.2.6 IBM Data Studio V3.2
- 1.3 InfoSphere Optim Performance Manager introduction
- 1.4 InfoSphere Optim Query Workload Tuner
- 1.5 Looking ahead
- Chapter 2. Planning your InfoSphere Optim Performance Manager deployment
-
Chapter 3. Installing and configuring Optim performance management tools
- 3.1 Installing and running InfoSphere Optim Performance Manager
- 3.2 Configuring InfoSphere Optim Performance Manager
- 3.3 Installing and configuring Extended Insight Client
-
3.4 Installing and configuring IBM InfoSphere OptimQuery Workload Tuner
- 3.4.1 InfoSphere Optim Query Workload Tuner information road map
- 3.4.2 Installing InfoSphere Optim Query Workload Tuner client
- 3.4.3 Upgrade InfoSphere Optim Query Workload Tuner and apply fix packs
- 3.4.4 Activate InfoSphere Optim Query Workload Tuner license
- 3.4.5 User security for InfoSphere Optim Query Workload Tuner
- 3.4.6 Configure database for query tuning
- 3.4.7 Deploying InfoSphere Optim Query Workload Tuner in a DMZ environment
- 3.4.8 Configuration to capture from InfoSphere Optim Performance Manager repository
- 3.4.9 InfoSphere Optim Query Workload Tuner client preference settings
- 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
- 5.1 Workflow for query analysis and tuning
- 5.2 Entry point of InfoSphere Optim Query Workload Tuner
- 5.3 Capture SQL statements from different sources
- 5.4 Run the tuning tools and advisors
- 5.5 SQL tuning report
- 5.6 Query formatter and annotation
- 5.7 Analyze the access plan
- 5.8 Statistics recommendations
- 5.9 Indexes recommendations
- 5.10 Compare and lock down access plan
- 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
-
8.1 Implementing a stage 2 configuration
- 8.1.1 Applying the best practices template configuration
- 8.1.2 Collect baseline monitoring for estimated cost distribution
- 8.1.3 Adjusting template definitions to better suit your environment
- 8.1.4 Collecting baseline monitoring for resource consumption
- 8.1.5 Adjusting concurrency thresholds
- 8.1.6 Defining thresholds to protect your system
- 8.1.7 Establishing a monitoring regime to ensure ongoing fitness
- 8.2 More best practices: Advanced configurations
- 8.3 Working with Workload Manager configurations
- 8.4 Autonomic performance objectives for workloads
-
8.1 Implementing a stage 2 configuration
- 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
- Related publications
- Back cover
Product information
- Title: Performance Management: Using IBM InfoSphere Optim Performance Manager and Query Workload Tuner
- Author(s):
- Release date: October 2013
- Publisher(s): IBM Redbooks
- ISBN: 9780738438450
You might also like
book
Work Item Management with IBM Rational ClearQuest and Jazz: A Customization Guide
&> The Complete Guide to Managing Work Items and Workflow with IBM Rational ClearQuest 7, IBM …
book
Getting Started with IBM InfoSphere Optim Workload Replay for DB2
This IBM® Redbooks® publication will help you install, configure, and use IBM InfoSphere® Optim™ Workload Replay …
book
Microsoft® SQL Server® 2008 Reporting Services Step by Step
Teach yourself how to build, manage, and access SQL Server 2008 reports one step at a …
book
DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration
IBM® DB2® tools for z/OS® support and exploit the most current versions of DB2 for z/OS. …