What is the source of data that populate PPADB2 option 12 Problem SQL from PPA Main Menu?

book

Article ID: 17940

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

When using option 12 Problem SQL, does PPA read the Plan table to populate that panel or getting the info from somewhere else like catalog?

Solution:

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.

Environment

Release:
Component: PPADB2