Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    74

    Unanswered: My db2advis can't execute

    Hi,

    I am trying to run DB2ADVIS but I have this error:
    Database is reporting the following error:

    error. The db2advis tool needs the explain tables and
    the advise tables to exist. Please create them
    using the EXPLAIN.DDL script in the misc subdirectory
    of the sqllib directory.

    But I have created all the table from EXPLAIN.DDL.
    Can someone help me?

    Thanks.
    The version is 8.2(upgrade from 8.1), OS is solaris

  2. #2
    Join Date
    Apr 2004
    Posts
    22
    Maybe the schema is different? Or the privilege of current user?
    **************************************
    Make progress everyday
    Mail: hoo.jimmy@gmail.com
    **************************************

  3. #3
    Join Date
    Jan 2003
    Posts
    74
    No, the schema is same, the user is instance user!

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    if you created explain tables before migration to 8.2 you need to drop explain tables and recreate them again. There was some changes in explain tables during version 8.1.
    Hope this helps,
    Grofaty

Posting Permissions

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