IBM® DB2® SQL Performance Analyzer for z/OS® is a performance tuning tool that extensively analyzes SQL queries without running them, enabling you to make better tuning decisions while minimizing cost.
DB2 SQL Performance Analyzer for z/OS helps you:
- Evaluate different “what if” scenarios quickly and economically to determine performance of various database design and production volumes
- Import and analyze SQL from various sources, including DB2 Query Monitor for z/OS and OMEGAMON XE for DB2 Performance Expert to provide expert tuning recommendations
- Produce and interpret cost reports
- Virtually add/drop indexes to evaluate effects on access path without actually making the change