Detector not capturing SQL errors in IDAA (IBM Db2 Analytics Accelerator)

Products

• Detector for DB2 for z/OS

Issue/Introduction

IDAA (IBM Db2 Analytics Accelerator) fails to run some SQL queries.  In IBM Accelerator Studio see the queries failing with State 22003.
Determined that a SQLCODE -413 was being returned to Db2 for a DECFLOAT conversion. However, Detector for Db2 for z/OS (PDT) 
had no record of these SQL -413 errors.

Is there some configuration required for Detector to capture SQL errors from queries that run in IDAA?

Resolution

Detector did not collect the -413 SQL errors because Db2 did not update the SQLCA with the -413 error information during the
execution of the failing OPEN statement. Since Db2 is not updating the SQLCA on the z/OS system with the -413 error information,
it is unlikely that any z/OS based application could detect the error and report it.