BMC APPTUNE for DB2

Identify and resolve SQL performance problems quickly

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

This product:

• Identifies the highest resource-consuming  SQL statements and makes recommendations to improve SQL performance
• Enables you to resolve SQL performance problems early in the application lifecycle and avoid introducing problems in a production environment
• Offloads up to 80% of its data collection work to zIIP engines
• Collects data efficiently (without DB2 performance traces) and optimizes retention of historical data for online analysis
• Provides comprehensive batch reports and the ability to offload to DB2 tables for analysis

With BMC APPTUNE for DB2, you will:

• Reduce the cost of running DB2 for z/OS applications
• Collect the data you need to generate an accurate picture of SQL and object performance
• Improve end-user response time
• Improve the performance and efficiency of your DB2 for z/OS applications