Improves performance of Db2 applications and systems

The IBM® Db2® Performance Optimization tools provide end-to-end performance monitoring and management for your IBM Db2® for z/OS® applications and systems.

They replace ad hoc methods with best practice technology that addresses the entire performance management lifecycle, including monitoring and tuning, helping to improve Db2 availability and reduce overall system costs.

The tools enhance return on investment with analytic support to address areas of assessment, administration and workload optimization. 

Features

Capabilities

• Manage the entire performance lifecycle across your Db2 for z/OS environment.
• **Enterprise-wide performance monitoring: **Monitor alerts and exceptions to identify performance slowdowns with minimal monitoring burden.
• **Expert advice with built-in advisors: **Optimize application performance and proactively tune SQL workloads through built-in recommendations, reducing the need for specialized skills. 
• **Autonomic alert functions: **Perform near real-time knowledge-based analysis of exception events.
• **Proactive problem prevention: **Monitor and analyze historical trends to prevent problems and plan for future capacity requirements.

Benefits

• **Optimize Db2 application performance: **Monitor, track and identify poorly performing SQL before moving to production. Expert advisors expedite application deployment by enhancing query design and statistics quality, and optimizing index values.
• **Manage performance beyond the database: **Identify areas where transactions consume resources for problem determination and to improve application efficiency. Gain a complete view of performance across the enterprise.
• **Lower costs and improve availability: **Align system resources with business priorities and improve resource usage to defer upgrades.