CA Bind Analyzer for DB2 for z/OSCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem Analyzer for DB2 for z/OS
Working with option '17 SQL Incompatibilities (IFCID 376)' to find DB2 11 incompatible SQL statements. For Dynamic SQL statments, when we try to locate the SQL text, either thru option 'System Statistics - SQL Incompatibilities (IFCID 376)' option or option 'SQL Analysis - SQL Exec Current Stats' option, we do not get the text.It says SQL text not in Cache.
Release: 1BINMI00200-19.0-Bind Analyzer-for DB2 for z/OS-MIPS Component:
For CA SYSVIEW for DB2 Release 19.0 this is currently working correctly, what you are seeing is not a bug. If the dynamic SQL statement is thrown out of the SQL dynamic statement cache before you try to view it from the SQL Incompatibilities (IFCID 376) screen, then you will not be able to see it.
The only solution for Release 19.0 would be to do two things:
1. Expand the dynamic statement cache. 2. Look at the items in the report quickly.
CA SYSVIEW for DB2 Release 20.0 has a new feature for the Dynamic SQL Text database so this has changed in this release, a new History file is defined to capture and retrieve the SQL text.