SQL-904 ERROR REASON 00D70025 UNSUCCESSFUL EXECUTION CAUSED UNAVAILABLE RESOURCE during EXPLAIN

Products

• Plan Analyzer for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The following error was encountered during a Plan Analyzer for Db2 for z/OS (PPADB2) explain: 

DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D70025, TYPE OF RESOURCE 00000220,  AND
RESOURCE NAME vcat.DSNDBC.dbname.tsname.I0001.A001  DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE

Resolution

Even though the Plan_Table and index for the Plan_Table existed, the SQL-904 was still occurring because all the required explain tables were not created. Based off the explain reports selected these Explain tables DSN_STATEMNT_TABLE, DSN_PREICAT_TABLE and DSN_FILTER_TABLE and their indexes were required to be present but were missing. For the indexes, the choice is to let the product auto-create them during the explain or by setting the PPA member within HGHLVL.CDBAPARM AUTOCRIX value to either Y or N.