Features and benefits
Applications and workloads need to be tuned to optimize performance and maximize system capacity. Poorly performing SQL can have a variety of problems: inaccurate statistics, inefficiently designed SQL statements, missing indexes, and poorly selected access plans. IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS simplifies and speeds up analysis for DBAs, developers, designers and other roles in the organization. It not only removes much of the tedium from query analysis, but provides expert recommendations to improve query workload performance. The improved workload performance and return on investment generated by Query Workload Tuner directly benefits the business.
IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS delivers a unique solution to the marketplace. It fosters teamwork and collaboration by helping DBAs and developers gain insights into SQL performance, identify and tune poorly performing query workloads. DBAs can identify and tune poorly performing queries and workloads with 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.Developers can launch InfoSphere Optim Query Workload Tuner from IBM Data Studio V3.1 and gain immediate insight into performance enhancements during development.
IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS provides an environment for performing query workload monitoring and tuning tasks. DBAs can 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. The following tools and advisors are provided along with the solution:
Workload Statistics Advisor provides advice on missing, outdated, and conflicting statistics and suggests additional statistics that should be gathered to improve query performance for those queries within a workload.
Workload Query Advisor makes recommendations based on best practice rules to modify SQL to improve overall performance.
Workload Index Advisor provides advice on new indexes that may improve performance of a workload. With Workload Index Advisor, use a set of predefined scenarios to perform an analysis based on the scenario selected.
Workload Table Report identifies key statistics, access path information, and physical database design information related to queries within a workload.
Workload Access Plan Explorer provides tabular view of the query plan for quicker diagnosis of performance issues
Workload Access Plan Comparison helps compare cost and plan structure, categorizes changes, and provides the ability to drilldown.
IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS delivers an easy to use interface which allows DBAs to access performance information at any time from any location. Also, its easy-to-use advisors enable DBAs of any skill level to monitor and tune queries to minimize performance problems helping you reduce downtime and associated costs that occur while responding to emergent problems. The net result makes your organization more resilient.
