BMC APPTUNE 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 APPTUNE for DB2 analyzes SQL statements to identify which statements are causing performance problems or using excess resources, and identifies potential improvements. BMC APPTUNE for DB2 uses an efficient data collection and reporting mechanism to minimize the cost of monitoring SQL on DB2 for z/OS, enabling you to collect more data and generate a more accurate picture of SQL and object performance in your environment.

Features and benefits

• Highlights the most expensive SQL statements and makes recommendations to improve SQL performance, resulting in faster problem resolution and reducing CPU costs
• Enables you to resolve SQL performance problems early in the application life cycle, improving performance and mitigating risk
• Identifies and helps resolve problems with table spaces and index spaces, improving performance
• Provides extensive batch reporting for offline analysis
• Collects data efficiently (without DB2 performance traces) and optimizes retention of historical data for online analysis  

Key differentiators

• Integrated BMC Common Explain - provides for immediate SQL analysis without the need for an additional product 
• Optimized data collection and storage - keeps more history for online analysis
• SQL Statement Cache Analysis application - provides details on SQL statements in the cache
• Comprehensive batch reports and the ability to offload to DB2 tables for SQL analysis
   

Related Products

• BMC SQL Performance for DB2