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-00.51.22.064897
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
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-00.51.22.064897
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