IDB 2 DYNSQLTX Panel disolays All Zeros

Document ID : KB000105908
Last Modified Date : 18/07/2018
Show Technical Document Details
Issue:
Values in R/DYNSQLTX Selected Dynamic SQL Statement in Cache are all zeros. Why?
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.