Plan Analyzer cost report does not display total cost
search cancel

Plan Analyzer cost report does not display total cost


Article ID: 8415


Updated On:


Plan Analyzer for DB2 for z/OS


Plan Analyzer for Db2 for z/OS (PPA) Enhanced Explain COST REPORT does not display the Total Cost.
The column Total Cost contains N/A.


The packages being explained were bound with EXPLAIN(NO) which indicates to PPA that the Plan Table information is missing.
This message in the explain output indicates that PPA had to perform an EXPLAIN PACKAGE to get the access plan information. 


The following packages were bound with EXPLAIN(NO), or PLAN_TABLE information was not available at the time the explain
was executed. An "EXPLAIN PACKAGE" statement has been executed to capture the access plan stored in the Db2 directory
to obtain Plan Analyzer CURRENT Explain information. As a result, only the access path is available for reporting.
The HINT_USED field in the SQL Statement Detail Report will then contain a value of "EXPLAIN PACKAGE:" . 


The EXPLAIN PACKAGE obtains the access path information from the DB2 directory where Db2 stores the information during a bind.
Unfortunately, only the PLAN_TABLE is obtainable from the Db2 directory and none of the cost information is available.
In order to get the cost information, the package must be bound with EXPLAIN(YES).