Articles & Content

Archives

F11 - Is IDAA Tuning Worth It?

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015



When queries are rerouted from DB2 to IDAA, they typically perform better by an order of one or two magnitudes. This presentation shows how effective data distribution and clustering within IDAA can further improve response times. We also discuss approaches to automatically detect and implement effective 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.