Optim Query Workload Tuner for DB2 for z/OS

Monitor and tune SQL to optimize application performance

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

Use the expert recommendations in Optim Query Workload Tuner to maximize application performance, reduce specialized skill requirements, and reduce the total cost of ownership for DB2 for z/OS® servers.

Manage and monitor the performance of SQL queries and workloads to proactively optimize physical database design and improve performance
Proactively solve query performance problems by enabling faster and deeper analysis of queries
Use the expert recommendations to maximize application performance, reduce specialized skill requirements, and reduce the total cost of ownership for DB2 for z/OS® servers
Reduce CPU cycles for statistics collection by collecting only what you need to benefit performance
Group your SQL statements into workloads to compare and track performance improvements
Manage database connections and tune queries holistically through integration with other IBM query tuning and monitoring solutions
NEW! Support for DB2 10 for z/OS and a new user interface to streamline query tuning workflow facilitate query tuning activities