Articles & Content

Archives

E10 - Is IDAA Tuning Worth It?

Topic: 2015 EMEA

Subtopic: Cross Platform DB2 for z/OS & LUW



When queries are rerouted from DB2 to IDAA, they typically perform better by an order of one or two magnitudes. This presentation shows how data distribution and clustering within IDAA can further improve response times. We also discuss approaches to automatically detect and implement efficient distribution and organization keys by analyzing IDAA data access pattern and data statistics. Reporting on IDAA benefits to management will also be highlighted, together with a checklist for IDAA capacity planning. Eventually, we compare IDAA to Oracle’s In-Memory Column Store option from a technical perspective including a comparison of query response times for different OLAP 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.