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

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

book

Article ID: 141299

calendar_today

Updated On:

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.