Results 1 to 3 of 3

Thread: db2advis

  1. #1
    Join Date
    May 2010
    Posts
    2

    Unanswered: db2advis

    Hi,

    I am new to db2. I am trying to run db2advis on a sql statement in my lab and facing the following error:
    db2advis -d sodev -f test -o sample

    Error Invalid Command-Line option [-e]

    0 solutions were evaluated by the advisor

    exiting with error code [-804]

    I also tried the following:

    db2advis -d sodev -i test.in -t 5

    Using user id as default schema name. Use -n option to specify schema
    Explain tables not set up properly for schema so1872
    The insert into the ADVISE_INSTANCE table has failed.

    0 solutions were evaluated by the advisor

    exiting with error code [-219]

    It would be great if some one can help me out..

    Thanks a lot.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Looks like you need to create the explain tables. You can run the DDL (db2 -tvf EXPLAIN.DDL) located in the following locations:

    • UNIX/LINUX- $HOME/sqllib/misc/EXPLAIN.DDL
    • Windows - \Program Files\IBM\SQLLIB\MISC\EXPLAIN.DDL


    Or you can use the the Visual Explain in the Control Center, and it will create the tables for you the first time you use it.

    Be sure to use the same userid to create the explain tables as you will use to execute db2advis (each user must have their own explain tables).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    May 2010
    Posts
    2
    Sorry Marcus, i couldn't log in to the forums from long time. Thanks a lot for the reply, will try that.

Posting Permissions

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