Why is Detector not capturing SQL errors in IDAA (IBM® DB2® Analytics Accelerator)?

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

IDAA (IBM® DB2® Analytics Accelerator) fails to run some SQL queries.  In IBM Accelerator Studio we can see the queries failing with State 22003. We determined that a SQLCODE -413 was being returned to DB2 for a DECFLOAT conversion.  However, Detector had no record of these -413 errors.

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

 

Environment

Release : 19.0

Component : CA Detector for DB2 for z/OS

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's unlikely that any z/OS based application could detect the error and report it.