Sysview for Db2 SQL incompatibilities explain options

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Within Sysview Performance Management Options for Db2 for z/OS (IDB2) navigating from R/INCOMPTD
SQL Incompatibilities (IFCID 376) panel. After input E for Explain next to a Plan, what option to choose
from the following Explain Menu Options?

Explain Menu Options
1 Display EXPLAIN data for packages/DBRMs
2 EDIT/EXPLAIN SQL statement from a data set
3 EDIT/EXPLAIN SQL statement entered in ISPF EDIT
4 EDIT/EXPLAIN SQL statement entered on SYSVDB2 panel
5 Manage EXPLAIN environment
 

Resolution

Utilize option Display EXPLAIN data for packages/DBRMs because this incompatibility was about a program.