BMC SQL Performance for DB2

Identify and resolve SQL performance problems quickly

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 Performance for DB2 enables you to pinpoint poorly performing SQL quickly and easily, so that you can reduce costs and improve response times. It provides tools to manage SQL performance across the application life cycle: in development, it validates SQL to ensure optimal performance characteristics like valid access paths and best-practice SQL coding techniques; in production, it captures metrics to identify and resolve performance problems. BMC SQL Performance for DB2 recommends optimal index usage, enables workload comparisons, and uses historical data to identify performance trends. BMC SQL Performance for DB2 consists of the following products:

• BMC APPTUNE for DB2
• BMC SQL Explorer for DB2
• Performance Advisor technologies, including Index Analysis, Workload Access Path Compare, and Reorg Advisor

Features and benefits

• Highlights the most expensive SQL statements and makes recommendations to improve performance, resulting in faster problem resolution and more efficient processing
• Enables you to resolve SQL performance problems early in the application life cycle, improving performance and mitigating risk
• Compares workload access paths to identify changes that occur when SQL is migrated across DB2 environments, enabling you to correct problems before they affect performance and availability
• Analyzes index usage and models changes to indexing strategy, reducing costs and improving response times
• Identifies and helps resolve problems with table spaces and index spaces, improving performance
• Gathers and manages historical performance data for trending and analysis
• Identifies which DB2 objects need reorganization, evaluating both space usage and performance metrics, thus reducing reorganizations

Key differentiators

• Integrated Common Explain - models changes in SQL statements and index design
• Reorg Advisor - uses SQL performance metrics and space usage to ensure accurate selection of reorganization candidates 
• Workload Access Path Compare - predicts performance impacts as SQL is migrated across DB2 environments. 
• Index Analysis component - identifies indexes that are being poorly utilized and SQL statements that are not effectively using DB2 indexes

Related Products

• BMC Database Performance for DB2