CA SYSVIEW OPTION FOR DB2. Dynamic SQL is not shown
Article ID: 263214
Updated On:
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Issue/Introduction
Dynamic SQL is not displayed in option 10 and 11 on CA SYSVIEW OPTION FOR DB2 MAIN MENU.
Is there a specific parameter to be customized?
Environment
Release : 20.0
Resolution
Go into the
TT Thread Term/Dynam DSNZPARM option
then select option
VZ View DSNZPARM Data
Ensure this parm is set to YES
Dynamic SQL statement cache support option. YES CACHEDYN
Feedback
Yes
No
Powered by
