Articles & Content


[E7] End-to-end Performance Analysis for Query Acceleration Using IDAA

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2013

IBM DB2 Analytics Accelerator (IDAA) is an integrated analytic query accelerator powered by Netezza. This presentation focuses on performance analysis for accelerated queries and considerations for IDAA optimization.

A step by step analysis of DB2 accounting and statistics  acceleration data will be presented to enable exploiters to understand how accelerated queries are performing.

In addition, query eligibility requirements will be discussed via analysis of augmented explain capabilities.

Finally, potential query tuning opportunities will be investigated to get the most out of IDAA accelerated queries.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.