EXPLAIN Facility and Predictive Analysis › Predictive Analysis Tools › Optimization Service Center and Visual EXPLAIN

Optimization Service Center and Visual EXPLAIN

As the complexity of managing and tuning various workloads continues to escalate, many database administrators (DBAs) are struggling to maintain quality of service (QoS) while also managing costs. IBM Optimization Service Center for DB2 for z/OS (OSC) is a Windows workstation tool that is designed to ease the workload of DBAs through a set of automation tools that help optimize query performance and workloads. You can use OSC to identify and analyze problem SQL statements and to receive expert advice about statistics that are gathered to improve the performance of problematic and poorly performing SQL statements on a DB2 subsystem. It provides the following:

• The ability to snap the statement cache
• Collect statistics information
• Analyze indexes
• Group statements into workloads
• Monitor workloads
• An easy-to-understand display of a selected access path
• Suggestions for changing a SQL statement
• An ability to invoke EXPLAIN for dynamic SQL statements
• An ability to provide DB2 catalog statistics for referenced objects of an access path, or for a group of statements
• A subsystem parameter browser with the keyword find capabilities
• The ability to graphically create optimization hints (a feature not found in Visual EXPLAIN V8)

You can use OSC to analyze previously generated EXPLAIN data, or to gather EXPLAIN data and clarify dynamic SQL statements.

OSC is available for DB2 V8 and DB2 9.