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.

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

Sorry Marcus, i couldn't log in to the forums from long time. Thanks a lot for the reply, will try that.