What is the source of data that populates the Plan Analyzer option 12 Problem SQL from PPA Main Menu

Products

• Plan Analyzer for DB2 for z/OS

Issue/Introduction

When using option 12 Problem SQL, does Plan Analyzer for Db2 for z/OS (PPA) read the Plan table to populate that panel or getting the info
from somewhere else like catalog?

Resolution

This option does not read the PLAN_TABLE but rather the PPA historical database tables(PTPA_ES_EXPL_1200, PTAN_STMT_1200, PTAN_SQL_1200, etc...)

Option 12 reporting is a PPA Historical Database report. An explain with Historical Database explain option set needs to be done to get the explain data saved into
the PPA historical database in order to be able to use this reporting option. Otherwise you'll end up with the following message:
PP028E: NO DATA WAS FOUND MATCHING THAT CRITERIA.