Hi,
I try to execute a query plan on a select statement
and when i start it this error occur:

[IBM][CLI Driver][DB2/LINUX] SQL0220N The Explain table
"DB2ADMIN.EXPLAIN_INSTANCE", column "EXPLAIN_OPTION" does not have the
proper definition or is missing. SQLSTATE=55002

I see the table and the field "EXPLAIN_OPTION" exist.

How can I do?
Thanks

Hi,

You probably don't have explain tables defined yet or you have migrated and didn't drop/create them.

1. So if tables EXPLAIN_xxxxx exist drop them.
2. Recreate explain tables: There is a file EXPLAIN.DLL in directory installation_path/sqllib/misc>. Move to this directory (cd command)
3. Execute this file with command:
Now, explain should work.

Hope this helps,
Grofaty