Incompatible changes for APPLCOMPAT levels in Db2 12
Before you start running applications at higher application compatibility (APPCLOMPAT) levels in Db2 12, you might need to make adjustments for certain behavior changes that are unrelated to use of new SQL capabilities.
Identifying potential incompatible changes in APPLCOMPAT levels with the IFCID 0376 trace
You can run package level accounting or monitor traces with IFCID 0239 and review field QPACINCOMPAT, which indicates an SQL incompatible change. If a trace is started for IFCID 0376, and the application runs at a lower APPLCOMPAT level, details about features and functions that have a change in behavior at higher APPLCOMPAT levels are written in field QW0376FN.
Descriptions of potential incompatible changes that for SQL statements that start running at higher APPLCOMPAT levels are available in the IFCID 0376 section of the DSNWMSGS flat file. The most current version of DSNWMSGS is available only for clients who have Db2 12 for z/OS® licenses. The information is in a PDF file. To locate this information, see Db2 12 for z/OS IFCID flat file (DSNWMSGS)
