AA_CNT and AA_TIME fields on Detector Package/DBRM SQL Display zeros when COBOL program contains Static SQL bound with QUERYACCELERATION(ENABLE) and executing in the IDAA box

Products

• Detector for DB2 for z/OS

Issue/Introduction

Why are the Detector for Db2 for z/OS (PDT) AA_CNT and AA_TIME fields on the Package/DBRM SQL Display zeros,
when the COBOL program contains Static SQL, is bound with QUERYACCELERATION(ENABLE) and is executing in the IDAA box.

Resolution

PDT calculates stats at the end of an SQL request so 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.