Optim Query Workload Tuner for DB2 for z/OS

Simplify and expedite query tuning for DB2 for z/OS

• Capture and group SQL statements into more meaningful workloads to tune, compare and track performance improvements.
• View estimates of performance improvements and use what-if analysis to test indexes virtually before creating them.

Improve performance

• Get advice on indexes, statistics, query revisions and access plans.
• Review formatted queries, identify high-cost plan operations and get recommendations to improve query performance.
• Compare before and after access plans to view performance improvements or regressions, and lock down where needed.

Increase efficiency and lower costs

• Identify and export queries and query workloads from IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS or IBM DB2 Query Monitor for z/OS to gain broader performance tuning.
• Access IBM Data Studio to tune queries during development, help improve developer skills and reduce production environment problems.
• Enable database administrators of different skill levels to monitor and tune queries.
• Use and share workload summary reports to help improve collaboration throughout the organization.