Product overview
These documents provide a general overview of InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner.
-
Features by product
This table lists the features for tuning SQL statements and query workloads, and the products in which those features are available. -
What's new in InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner, Version 3.1
This page describes the features that are new in version 3.1. -
InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows product overview
This topic provides an overview of the product and links to key tasks for the product. -
InfoSphere Optim Query Tuner for DB2 for z/OS product overview
This topic provides an overview of the product and links to key tasks for the product. -
InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows product overview
This topic provides an overview of the product and links to key tasks for the product. -
InfoSphere Optim Query Workload Tuner for DB2 for z/OS product overview
This topic provides an overview of the product and links to key tasks for the product. -
InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner product page
This page is the home page on ibm.com for these products.
Installing and configuring
These documents provide information about how to install InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner.
-
System requirements for InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner, Version 3.1
This document describes the minimum system requirements to install InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner. -
Quick Start guide for InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows
This guide gets you started with a typical installation. -
Roadmap for installing and configuring InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows
This roadmap provides an overview of the tasks for installing and configuring the product. -
Quick Start guide for InfoSphere Optim Query Tuner for DB2 for z/OS
This guide gets you started with a typical installation. -
Roadmap for installing and configuring for InfoSphere Optim Query Tuner for DB2 for z/OS
This roadmap provides an overview of the tasks for installing and configuring the product. -
Quick Start guide for InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
This guide gets you started with a typical installation. -
Roadmap for installing and configuring InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
This roadmap provides an overview of the tasks for installing and configuring the product. -
Quick Start guide for InfoSphere Optim Query Workload Tuner for DB2 for z/OS This guide gets you started with a typical installation.
-
Roadmap for installing and configuring InfoSphere Optim Query Workload Tuner for DB2 for z/OS
This roadmap provides an overview of the tasks for installing and configuring the product. -
Installing help content locally
You can download the help files, so that you can access them without having to connect to the Internet.
Configuration
These documents provide information about how to configure data servers so that you can tune SQL statements or query workloads that run on them.
-
Configuring a DB2 for Linux, UNIX, and Windows database for query tuning
You must configure your DB2 for Linux, UNIX, and Windows database before you start tuning SQL statements or query workloads. -
Configuring a DB2 for z/OS subsystem for query tuning
You must configure a DB2 for z/OS subsystem for tuning SQL statements and workloads by using the InfoSphere Optim Query Tuner client or by running JCL on the subsystem.
Tuning
These documents explain the general order of steps for tuning SQL statements and query workloads.
-
Tuning single SQL statements
This topic explains the general order of steps for using the advisors, analysis tools, and reports to tune SQL statements. -
Tuning query workloads that run on DB2 for Linux, UNIX, and Windows
This topic explains the general order of steps for using the advisors to tune query workloads. -
Tuning query workloads that run on DB2 for z/OS This topic explains the general order of steps for using the advisors to tune query workloads.
-
Comparing access plans and SQL statement execution costs for DB2 for z/OS
Compare access plans to determine how SQL statement performance on a DB2 for z/OS subsystem is affected by an application change (such as adding a SQL statement to a program and rebinding the package), by an environment change (such as adding an index), by release migration, or by running RUNSTATS. You can also compare access plans to validate the results of a tuning activity.
Capturing environments of SQL statements and query workloads that run on DB2 for z/OS
This document explains how to collect data that you can send to IBM
Support when you are tuning SQL that runs on DB2 for
z/OS.
Capturing environments of SQL statements and query workloads
that run on DB2 for z/OS
Support
The support pages list tech notes and other documents that can help you troubleshoot problems or find out when a Fix Pack is available. The forum is a great place to talk with other users of these products and to ask the development team questions.
-
Support page for InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows
-
Support page for InfoSphere Optim Query Tuner for DB2 for z/OS
-
Support page for InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows
-
Support page for InfoSphere Optim Query Workload Tuner for DB2 for z/OS
