Improve management and prevention

Enable built-in advisors to speed performance path enhancements with suggestions on how to improve query design, statistics quality and index values. Scale and optimize to handle business growth without corresponding increases in staff. Improve queries and workloads with IBM Db2 Analytics Accelerator.

Diagnose problems

Integrate workloads after problem identification to provide expert tuning recommendations. Virtually add or drop indexes to evaluate effects on access path without making changes. Handle transaction workloads using less system resources, such as CPU and storage.