IDB 2 DYNSQLTX Panel disolays All Zeros

Article Id: 105908

Status: Published

Updated On: 18-07-2018 13:27

Products:

CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA 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.