InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows

Get expert recommendations for managing query workload performance

IBM® InfoSphere® Optim™ Query Workload Tuner for DB2 for Linux, UNIX and Windows provides expert recommendations to help you improve the performance of query workloads. It can help you optimize application performance, reduce the need for specialized skills and lower total cost of ownership and now includes advise for the new DB2 for Linux, UNIX and Windows 10.5 column-organized tables.

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows helps you:

Simplify and expedite query tuning with features that allow you to tune complete workloads.
Improve performance with guidance to help you improve query design, statistics quality and database design.
Help increase efficiency and lower costs with a collaborative platform that reduces specialized skill requirements and integrates with other IBM tools.

Simplify and expedite query tuning

Capture and group SQL statements into 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 statistics, indexes, column-organized tables, statistical views, materialized query tables (MQTs), multidimensional clustering and redistribution of data over database partitions.
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.
Get recommendations on which tables to convert from row- to column-organized format and an estimated performance gain if converted.

Help increase efficiency and lower costs

Identify and export queries and query workloads from IBM InfoSphere Optim Performance Manager for Linux, UNIX and Windows to gain broader performance tuning.
Tune queries during development, and help improve developer skills and avoid problems in the production environment using IBM Data Studio, which is included.
Enable database administrators of different skill levels to review and tune queries.
Use and share workload summary reports to help improve collaboration throughout the organization.

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows resources

Demo: Database Management Solutions for IBM DB2
Learn how to manage data growth, quickly deploy applications and reduce total cost of ownership using IBM DB2 solutions.

Brochure: Performance management and optimization solutions for IBM DB2 for Linux, UNIX and Windows
Discover how to manage and optimize performance of your database environment.

Ebook: Database management solutions for the era of big data
This e-book explores how database management solutions for IBM® DB2® for Linux, UNIX and Windows help you increase productivity and maximize the efficiency of your database resources.