Overview of IBM InfoSphere Optim Query Workload Tuner, Version 4.1.0.1

IBM® InfoSphere® Optim™ Query Workload Tuner helps database administrators and SQL developers optimize the performance of SQL statements in applications that query DB2® for Linux, UNIX, and Windows databases or that query DB2 for z/OS® subsystems.

SQL optimization is critical to improving application performance. When SQL queries and workloads in applications are not tuned for optimal performance, application degradation can put revenue at risk, lower customer satisfaction, and increase infrastructure costs.

For a list of some of the scenarios in which query-workload tuning can be helpful and procedures that you can follow for each scenario, see Scenarios for tuning query workloads.

To learn how to do tasks that are related to tuning query workloads that run on DB2 for Linux, UNIX, and Windows, see Tuning query workloads that run on DB2 for Linux, UNIX, and Windows.

To learn how to do tasks that are related to tuning query workloads that run on DB2 for z/OS, see Tuning query workloads that run on DB2 for z/OS.

To learn how to do tasks that are related to tuning single SQL statements that run on DB2 for Linux, UNIX, and Windows or DB2 for z/OS, see Tuning single SQL statements.


Feedback