Sysview for Db2 BTRINCMT report does not show the SQL statement

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

The Sysview Performance Management Option for Db2 for z/OS (IDB2) SQL incompatibility detail report BTRINCMT report does not 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 IFCID 376 with a STMT ID of zero. This seems to be an IBM bug (or some other non-described behavior).

Resolution

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