Which Plan Analyzer loadlib contains modules PPL@EXE1 and PPA@EXE1

Products

• Plan Analyzer for DB2 for z/OS

Issue/Introduction

Which Plan Analyzer for Db2 for z/OS (PPA) loadlib contains modules PPL@EXE1 and PPA@EXE1.

Resolution

PPL@EXE1 is located in the hlq.CDBALOAD and it is a component of the stored procedure explain.
PPA@EXE1 is an object module not a load module that resides in multiple load modules such as PPL@TARG.