When running an explain plan, the following message is displayed:
"The access plan tables need to be installed. Would you like to run the install scripts..."
CAUSE 1: Explain plan tables need to exist for the SQLID that runs the query.
CAUSE 2: In version 5.6 Editor, If the SQLID dropdown is used to select a different user, Toad attempts to pick up explain tables for the user that logged on, rather than the SQLID (This is a known defect). If the plan tables don't exist in the login user, then the above message is displayed.
CAUSE 3. In version 6.0 and 6.1, if 'Default Schema/AuthID' is completed in the login window and the plan tables do not exist for the login user, then the above message will display. This is a defect (TDB-2289)
RESOLUTION 1:
Run the script to create the relevant plan tables. If you don't have permission to create tables in the current SQLID have the DBA create the explain plan tables for you and run the explain plan again.
If the tables exists and those are not on the same schema of
RESOLUTION 2:
Issue is resolved in version 6.0. The latest version of Toad for DB2 can be downloaded here.
For CAUSE 3:
STATUS:
Waiting for fix in a future release of Toad for DB2 z/OS
WORKAROUND:
Do not use 'Default Schema/AuthID' from the login window. Use the drop-downs at the top of the Editor to switch to the required schema and SQLID.
You can use plan tables that are not in the same schema as your AuthID by creating aliases for the plan tables you want to use. A DBA admin can provide you with the required authority to create those aliases.
