Why are the AA_CNT & AA_TIME fields on the DT Package/DBRM SQL Display zeros, when my COBOL program contains Static SQL, is bound with QUERYACCELERATION(ENABLE) & is executing in the IDAA box?

Document ID : KB000015695
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

This document explains why the AA_CNT & AA_TIME fields on the DT Package/DBRM SQL Display may be zeros, even though a COBOL program contains Static SQL, is bound with QUERYACCELERATION(ENABLE) & is executing in the IDAA box.

Question:

Why are the AA_CNT & AA_TIME fields on the DT Package/DBRM SQL Display zeros, when my COBOL program contains Static SQL, is bound with QUERYACCELERATION(ENABLE) & is executing in the IDAA box? 

Environment:
z/OS 1.11 and above.
Answer:

Detector calculates stats at the end of an SQL request - so that only after it ends will values show up for a particular statement. Also at the end of the statement, those values are rolled up to the Plan and Program/Package level. This is true for all statements, not just those that run on the IDAA box.