Display SQL text in SQL Dynamic Cache within Sysview for Db2

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Working with option '17 SQL Incompatibilities (IFCID 376)' to find Db2 11 incompatible SQL statements within Sysview Performance Management Option for Db2 for z/OS (IDB2).
For Dynamic SQL statements, when attempting to locate the SQL text, either thru option 'System Statistics - SQL Incompatibilities (IFCID 376)' option or
option 'SQL Analysis - SQL Exec Current Stats' option, do not get the text. It says SQL text not in Cache.

Resolution

For IDB2 release r19 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 IDB2 r19 would be to do two things:

1. Expand the dynamic statement cache
2. Look at the items in the report quickly

IDB2 release r20 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.