Articles & Content

Archives

E02 - Investigating the IDAA with SMF

Topic: 2014 EMEA

Subtopic: Cross Platform DB2 for z/OS & LUW



The IBM DB2 Analytics Accelerator (IDAA) is a high performance solution for DB2 on z/OS. It delivers faster query responses transparently to the user.
The IDAA can be considered as a virtual DB2 component working under DB2 control: the DB2 Optimizer will be responsible for deciding whether to dynamically “offload” a query to the IDAA or not.
IBM studies and customer experiences show that big advantages can be obtained in terms of savings of CPU and I/O capacity particularly for queries which scan large amounts of data.

To analyse IDAA activity in detail the SMF records produced by statistics and accounting traces need to be used. These provide a lot of metrics, but unfortunately their meaning is not always straightforward or well documented.

In this presentation we will discuss these metrics showing what you have to do in order to use them safely and effectively.



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.