Deep Dive into IBM DB2 Analytics Accelerator Query Acceleration

Project and Program: Information Management, Database

Tags: Proceedings , SHARE in Anaheim 2012 , 2012

The IBM DB2 Analytics Accelerator (IDAA) brings revolutionary query performance to DB2 for z/OS for selected queries with great cost/performance characteristics, and opens up unprecedented opportunities to turn data to real-time business insights on System z. This presentation will give an inside view of DB2 IDAA query acceleration and provide the best practices in using IDAA to optimize DB2 workload. It will cover DB2 query acceleration criteria, what queries are suitable for IDAA, how IDAA impacts the query performance (both acceleration eligible or not eligible), tips and best practices to maximize IDAA sweet spot while minimizing the impact to non-eligible queries. Guogen Zhang ; IBM Corporation; Ruiping Li ; IBM Corporation

Back to Proceedings File Library