ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
IDB 2 DYNSQLTX Panel disolays All Zeros
Article ID: 105908
Updated On:
Products
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
Issue/Introduction
Values in R/DYNSQLTX Selected Dynamic SQL Statement in Cache are all zeros. Why?
Environment
Release:
Component: CIDB
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.
Feedback
Yes
No
Powered by
