IDB2's BTRINCMT report doesn't show the SQL statement

book

Article ID: 193433

calendar_today

Updated On:

Products

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

Issue/Introduction

The IDB2 SQL incompatibility detail report BTRINCMT report doesn't show the SQL statement (as stated in the documentation sample report.)
Is there a parameter that needs to be enabled to obtain the SQL via the BTRINCMT report?  IFCID 376 is enabled.
 

 

Cause

There is no SQL Text for IDCID 376 with a STMT ID of zero. This seems to be an IBM bug (or some other non-described behavior).

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

This is unexpected behavior as documented in IBM PMR TS003881725 with documentation updates via IBM apar PH26776