SQL Incompatibilities IFCID 366 V9CHRFUN Applications Affected By Db2 Changes

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

SQL Incompatibilities (IFCID 366) option in Sysview Performance Management Option for Db2 for z/OS (IDB2) shows a list of SQL incompatibilities.
Please assist what action needs to be taken to fix this?

Resolution

Db2 11 introduced IFCID 376 as a serviceability trace record. This trace record identifies application SQL statements that are affected by
changes to Db2 and the reason the SQL statement is affected. 

This request provides a trace of SQL executed by statement ID. It lists the plan, package collection, program name, SQL statement information
and the reason the SQL statement is affected. This trace record is written once for each unique dynamic and static statement.

It is for you to determine the programs and SQL statements that are affected so that they can be modified to work with the new Db2 behavior.