BMC SQL Explorer for DB2

Optimize DB2 on z/OS performance across the application lifecycle 

SQL statements provide access to DB2 data, and inefficient SQL causes performance problems for DB2 on z/OS applications. Because performance problems increase costs and affect service levels to end users, you must be able to manage SQL performance continuously, from initial development to production. When performance problems occur, you need to find and fix them quickly.

BMC solution

BMC SQL Explorer for DB2 analyzes SQL statements to ensure that they meet best-practice SQL coding standards and deliver optimal performance. Using BMC SQL Explorer for DB2, you can identify performance problems early in the application lifecycle and avoid the risk of introducing problems in production applications. It enables you to migrate access path statistics within and across DB2 subsystems. 

Features and benefits

• Analyzes SQL statement syntax to enforce best-practice SQL coding standards, ensuring that SQL statements provide optimal performance at the lowest cost 
• Provides detailed access path and predicate analysis with BMC Common Explain
• Provides detail on which DB2 objects are being accessed
• Enables what-if analysis so that you can see the impact of changes to SQL statements before implementing the change
• Migrates access path statistics within and across DB2 subsystems, improving productivity for developers and DBAs

Key differentiators

• Integrated BMC Common Explain -  expands on standard DB2 Explain, providing detailed access path analysis and reports, including predicate report, object statistics, and rules violations 
• Integration BMC MAINVIEW for DB2, BMC APPTUNE for DB2, and BMC CATALOG MANAGER for DB2

Related Products

• BMC SQL Performance for DB2