Rate this page   Save this item Print this page Email this page

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
     

 

Related Products
This product is part of: BMC SQL Performance for DB2
Other products in the suite: BMC APPTUNE for DB2
BMC Performance Advisor Technology
Related products: BMC CATALOG MANAGER for DB2
BMC Database Performance for DB2
BMC System Performance for DB2

 

 
Contact Us
 

contact us
 
Quarterly eNewsletter
 

Subscribe to mainframe Database Insights to stay current with DB2 and IMS administration, performance and recovery techniques and best practices.

Subscribe Now

 
Mainframe Revolution Blog
 

The New Era of ITSM

Get the latest information in the Mainframe Revolution blog

Business runs on IT. IT runs on BMC Software.