By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,948 Members | 1,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,948 IT Pros & Developers. It's quick & easy.

Problem with db2advis

P: 19
Hi all,

I am getting the following problem when i run the db2advis.

]$ db2advis -d sample -i name3.sql -n db2inst1 -o db2advise.out

0 solutions were evaluated by the advisor

exiting with error code [-1013]

If i execute the following stmt.
db2advis -d prod1 -s "select * from users"
I am getting the following error.

Using user id as default schema name. Use -n option to specify schema
execution started at timestamp 2008-04-01-
Recommending indexes...
I'm having trouble processing the following query, statement [1] in the workload

Please check the syntax:
SQL: <select * from users>

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.

0 solutions were evaluated by the advisor

exiting with error code [-220]

I have all the explain tables created

Please help me with this.

Thanks a ton in advance
Mar 25 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.