Overview
Learn more
Downloads
Use and maintain
IBM DB2 Optimization Expert provides workload and query tuning advice.
![]()
It helps to maximize application performance, reduce specialized skill requirements, and reduce the total cost of ownership DB2 for z/OS servers. DB2 Optimization Expert offers a comprehensive set of expert advisors to:
- Increase quality of service by proactively solving problems before they occur
- 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
- With DB2 Optimization Expert V2.1, users can:
- Perform query-based analysis and receive expert advice to quickly react to serviceability issues
- Define and analyze workloads to proactively optimize physical database design
- Aggregate performance data in a query warehouse to readily see and track the affect of changes over time
- Use an integrated desktop with IBM Data Studio, Rational, InfoSphere, and other products built on Eclipse V3.4.1, to enhance value and usability.
Product framework
Family overview
See the complete family of DB2 Tools for z/OS
See how other Data Management Tools can help drive your business
See the DB2 for z/OS page for all your DB2 needs.
Additional products, services and solutions
Products
Monitors and tunes the SQL statements that run on DB2 9 for z/OS and DB2 for z/OS Version 8 subsystems and data sharing groups.
Solutions
Checks the performance health of the DB2 subsystems
