Return
-
Title
Explain Plan SQL in packages error: Plan is not available. -
Description
When viewing the explain plan of individual SQL statements from a package, the following error is thrown:
Plan is not available.
-
Resolution
WORKAROUND
None
STATUS
Issue fixed in version 4.7.1. The latest version of Toad for DB2 can be downloaded at SupportLink.
-
Defect ID
ST81212 -
Additional Information
To avoid the "Plan not Available" message when attempting to see Access path as part of the SQL tab in Browser - Packages - you can bind with the EXPLAIN(YES) parameter.