Hi

I am working from a DB2 windows client(V 8.1), accessing the server(V 8.2) on AIX.

When I am trying to display an access plan for any query I am getting the following Error

SQL0220N The Explain table "DB2INST1.EXPLAIN_INSTANCE", column "EXPLAIN_OPTION"
does not have the proper definition or is missing. SQLSTATE=55002

I have checked the Explain Tables, all the definition is correct. But still I am getting this error..?

Hi,
it looks like you have migrated from v7 to v8 with backup database / restore database operation. Explain tables have been changed from v7 to v8. So you need to drop explain tables manually with drop table commands. Then recreate explain tables with EXPLAIN.DLL script. This script is by default on the following directory: home/db2inst1/sqllib/misc on server site.
This script creates new tables compatible on v8.
Hope this helps,
Grofaty