BMC Pool Advisor for DB2 - BMC

BMC.com » Products » Product Listing » BMC Pool Advisor for DB2

BMC Pool Advisor for DB2

DB2 on z/OS uses large memory structures (pools) to manage, modify, and access data. Poorly configured pools degrade performance, increasing CPU cost and reducing service levels. Dynamic workloads present challenges for optimizing DB2 storage pools.

BMC solution

BMC Pool Advisor for DB2 removes the guesswork that is involved in performance tuning. It proactively optimizes DB2 storage pools continuously, ensuring that applications run faster and more efficiently by using fewer CPU cycles and reducing I/O. BMC Pool Advisor for DB2 automatically responds to unexpected fluctuations in DB2 workloads.

Features and benefits

Monitors storage pool usage in real-time, identifying and resolving problems and reducing the risks associated with workload fluctuations
Monitors overall group buffer efficiency, factoring in checkpoints, castout problems, and critical read or write failures
Monitors and offers expert advice for the EDM, Dynamic Statement Cache, Sort, and RID DB2 storage pools, improving overall throughput and reducing costs
Collects detailed object performance metrics without the need for expensive performance traces, reducing cost of monitoring, and keeps extensive history data online

Key differentiators

Dynamic monitoring and reconfiguration of DB2 storage pools - reduces risk and improves overall throughput for your DB2 subsystem. Exclusive BMC technology.
Configuration Advisor - evaluates overall buffer throughput for the DB2 subsystem, recommending and implementing changes to object placement and buffer pool configuration
Group Buffer Pool Advisor - recommends changes to improve GBP usage, reducing cost and improving performance in DB2 data sharing environments.
Integration with BMC MAINVIEW for DB2 - enables extensive object analysis
Integration with BMC OPERTUNE for DB2 – allows you to make configuration changes that cannot be done with DB2 commands