PPA regular and expert mode

Products

• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Plan Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS

Issue/Introduction

How to switch between two QE(Quick Explain) regular and expert mode screens one is PPA Quick Explain,  the other is  PPA Quick Explain Data Editor

 

 

Environment

Release : 20.0

Component : CA Plan Analyzer for DB2 for z/OS

Resolution

To switch between two QE(Quick Explain) screens one is PPA Quick Explain,  the other is  PPA Quick Explain Data Editor you need to change the following PPA Profile parm called:
Expert Mode default ===> N (Y=Expert, N=Regular)
The parm is accessed by invoking PPADB2 Profile (from PPA MAIN MENU) with the PF code.