Sysview for Db2 DYNSQLTX panel displays all zeros
Article ID: 105908
Updated On: 10-04-2023
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Issue/Introduction
The Sysview Performance Management Option for Db2 for z/OS (IDB2) values in request
R/DYNSQLTX Selected Dynamic SQL Statement in Cache are all zeros.
Resolution
Dynamic SQL text was not collected during the selected interval. To enable it IFCIDs 316 and 401 need to be
included in the HIST-STATS-RECS Data Collector SYSPARMS parameter.
Feedback
Was this article helpful?
Yes
No
Powered by
