Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    12

    Angry Unanswered: Query Plan Error...

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    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:
    Code:
    db2 -tvf EXPLAIN.DLL
    Now, explain should work.

    Hope this helps,
    Grofaty
    Last edited by grofaty; 02-16-05 at 08:51.

Posting Permissions

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