InfoSphere Optim Query Workload Tuner for DB2 for z/OS

Monitor and tune SQL to optimize application performance

Overview

Learn more

Downloads

Demo

Use and maintain

InfoSphere Optim Query Workload Tuner for DB2 for z/OS provides expert recommendations to DBAs to help improve performance of a query workload.

InfoSphere Optim™ Workload Tuner for DB2 for z/OS provides expert recommendations to maximize application performance, reduces specialized skill requirements, and reduces the total cost of ownership for DB2 for z/OS® servers.

Group your SQL statements into workloads to compare and track performance improvements.
Identify and tune poorly performing query workloads.
Manage and monitor the performance of SQL queries and workloads to proactively optimize physical database design and improve performance.
Launch InfoSphere Optim Query Workload Tuner from IBM Data Studio V3.1 and gain immediate insight into performance enhancements during development.
Tighter integration with other SQL tuning and monitoring solutions including DB2 Query Monitor, DB2 Path Check for z/OS, DB2 SQL Performance Analyzer for z/OS, and Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS.
Work with Workload Access Plan Comparison, which helps compare cost and plans structure and Workload Access Plan Explorer that helps narrow down performance problems quicker
Reduce downtime and associated costs that occur while responding to emergent problems.