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

BMC SQL Performance for DB2

Identify and resolve SQL performance problems quickly

Identify and resolve SQL performance problems quickly to improve response time and reduce peak MIPS

This solution:

  • Pinpoints poorly performing SQL quickly and easily in all phases of the application lifecycle
  • Compares workload access paths to identify changes when SQL is migrated across DB2 environments
  • Analyzes index usage and models changes to indexing strategy
  • Gathers and manages historical performance data for trending and analysis
  • Provides Performance Advisors to intelligently automate application tuning
  • Offloads up to 80% of data collection work to zIIP engines

With BMC SQL Performance for DB2, you will:

  • Reduce costs and delay expensive upgrades
  • Improve response times
  • Efficiently manage SQL performance throughout the application life cycle
  • Reduce the risk of introducing inefficient application code in a production environment
  • Avoid unnecessary reorganizations


Related Products
Products in the suite: BMC APPTUNE for DB2
BMC SQL Explorer for DB2
BMC Performance Advisor Technology
Related product: BMC Database Performance for DB2
BMC System Performance for DB2


Contact Us

contact us
Celebrate BMC Mainframe Innovations

Join BMC in celebrating 50 years of the mainframe and the innovations that continue to redefine what computing was meant to be.

Mainframe 50th Anniversary
Mainframe Revolution Blog

The New Era of ITSM

Get the latest information in the Mainframe Revolution blog