CA SYSVIEW OPTION FOR DB2. Dynamic SQL is not shown
search cancel

CA SYSVIEW OPTION FOR DB2. Dynamic SQL is not shown

book

Article ID: 263214

calendar_today

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 

 

CACHEDYN