IDB 2 DYNSQLTX Panel disolays All Zeros
Article ID: 105908
Bind Analyzer for DB2 for z/OS
SQL-Ease for DB2 for z/OS
SYSVIEW Performance Management Option for DB2 for z/OS
Plan Analyzer for DB2 for z/OS
Subsystem Analyzer for DB2 for z/OS
Values in R/DYNSQLTX Selected Dynamic SQL Statement in Cache are all zeros. Why?
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.