BMC Pool Advisor for DB2

Optimize buffer pool usage to reduce costs and improve service

Dynamically tune buffer pool performance to reduce costs and improve performance

This product:

• Optimizes DB2 storage pools continuously, ensuring that applications run faster and more efficiently
• Monitors and offers expert advice for the EDM, dynamic statement cache, Sort, and RID DB2 storage pools
• Dynamically monitors group buffer efficiency, factoring in checkpoints, castout problems, and critical read or write failures
• Evaluates buffer throughput for the DB2 subsystem, recommending and implementing changes to object placement and buffer pool configuration
• Collects detailed object performance metrics without the need for expensive performance traces, and keeps extensive history data online

With BMC Pool Advisor for DB2, you will:

• Improve performance and throughput in real time
• Reduce costs by using fewer CPU cycles and reducing I/O
• Automatically respond to unexpected fluctuations in DB2 workloads