User gets the error/warning below when trying to run explain plan after migrating Toad from version 7.4 to version 8.0:
“The Access Plan tables are incomplete or out of date and need to be reinstalled. Would you like to run the recreation script for these tables?
Using plan tables from SYSTOOLS schema is specified in preference, but plan tables were created in current schema. So you have to either uncheck 'Use plan tables SYSTOOLS schema' option in preference window or drop plan tables in current schema.
The following plan tables do not exist under the SYSTOOLS schema. DB2 LUW requires these tables to provide access plan details. DB2 LUW also provides a script EXPLAIN.DDL to create the plan tables. You may find it under your <DB2 LUW home> misc directory.”
In line 3, it says: “So you have to either uncheck 'Use plan tables SYSTOOLS schema' option in the preference window.”
That’s the first issue, as this option does not exist in the Toad preferences.
The second issue is that it is not possible to use the tables that were being used before.
WORKAROUND
Drop the tables and recreate them in the SYSTOOLS schema.
To do that, enter the tablespace name and then click yes.
This will generate a script that needs to be run (F5).
STATUS
Waiting for fix in a future release of Toad for DB2
