Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007

    Question Unanswered: DB2 Access Plan-EXPLAIN TABLE ERROR


    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..?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 1
    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,
    Last edited by grofaty; 07-25-07 at 08:38.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts