PP028E NO DATA WAS FOUND MATCHING SELECTION CRITERIA in Plan Analyzer

Products

• Plan Analyzer for DB2 for z/OS

Issue/Introduction

PP028E: No data was found matching selection criteria' with any dialog using Hversion in Plan Analyzer for Db2 for z/OS (PPA).

Resolution

Check that DBOPTS is set to the correct value. The "DBOPTS" command is used to display/set Plan Analyzer's database retrieval method.

The valid settings are: 

AUTO - Retrieve only AUTO type data. MANUAL - Retrieve only MANUAL type data. BOTH - Retrieve Both AUTO and MANUAL type data.
ALL - Retrieve Both AUTO, MANUAL, and STRATGEY type data.