CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem Analyzer for DB2 for z/OS
Issue/Introduction
Values in R/DYNSQLTX Selected Dynamic SQL Statement in Cache are all zeros. Why?
Environment
Release: Component: CIDB
Resolution
Dynamic SQL text were not collected during the selected interval. To Enable it IFCIDs 316 and 401 need to be included in the HIST-STATS-RECS datacollector sysparms parameter.