BMC SQL Explorer for DB2

Optimize DB2 on z/OS performance across the application lifecycle

Fix problems before introducing them into a production environment

This product:

• Analyzes SQL statement syntax to enforce best-practice SQL coding standards, ensuring that SQL statements provide optimal performance at the lowest cost
• Enables “what-if” analysis so you can see the impact of changes on SQL statements before implementing them
• Provides detail on which DB2 objects are being accessed
• Migrates access path statistics within and across DB2 subsystems
• Includes the Integrated BMC Common Explain, which  expands on standard DB2 Explain, providing detailed access path analysis and reports, including predicate report, object statistics, and rules violations

With BMC SQL Explorer for DB2, you will:

• Reduce the risk of implementing performance problems in a production environment
• Improve productivity of application developers and DBAs