Optim Query Workload Tuner for DB2 for z/OS

Monitor and tune workloads and queries to optimize application performance

Overview

Learn more

Use and maintain

Previously known as DB2 Optimization Expert for z/OS, Optim Query Workload Tuner for DB2 for z/OS extends the functionality of IBM Optim Query Tuner for DB2 for z/OS

Maximize application performance, reduce specialized skill requirements, and reduce the total cost of ownership for DB2 for z/OS® servers. Optim Query Workload Tuner can provide expert recommendations to DBAs to improve performance for a workload.

Manage and monitor the performance of SQL queries and query workloads to proactively optimize physical database design and to improve performance
Proactively solve query performance problems before they cause costly outages by enabling faster and deeper analysis of queries with performance issues -
Accelerate problem resolution providing expert guidance and decreasing reliance on special skills
Lower total cost of ownership by optimal exploitation of DB2 for z/OS, eliminating the need for costly manual analysis, reducing CPU cycles for statistics collection by collecting only what you need to benefit performance.,
Aggregate performance data in a query warehouse to readily see and track the effect of changes over time
Group your SQL statements and workloads, and maintain versions of statements and analysis results to compare and track performance improvements.
Manage database connections and tune queries in the same desktop environment as Optim Development Studio and InfoSphere Data Architect, providing seamless access to tuning capabilities from any task.
Operating systems supported: HP Unix, Linux, Windows, z/OS