470,591 Members | 2,137 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

db2advis giving trouble

hello,

db2advis gave me error like
db2advis -d ABC -s "select * from sysibm.sysdummy1" -m MIC -c USERSPACE1 -n XYZ -l 5000
execution started at timestamp 2006-11-15-09.51.37.046473
Using the default table space name USERSPACE1
Recommending indexes...
Recommending MQTs...
Recommending Multi-Dimensional Clusterings...
Found 6 user defined views in the catalog table
Found [4] candidate MQTs
Getting cost of workload with MQTs
I'm having trouble processing the following query, statement [1] in the
workload

Please check the syntax:
SQL: <select * from sysibm.sysdummy1>

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.

12 solutions were evaluated by the advisor

exiting with error code [-220]

i have already created explain and advise tables and verified that they
exist.
please help if someone experiences the same.

Nov 15 '06 #1
2 5185
Make sure you have the explain tables for the user who invokes the
db2advis with proper permissions.
hello_db2 wrote:
hello,

db2advis gave me error like
db2advis -d ABC -s "select * from sysibm.sysdummy1" -m MIC -c USERSPACE1 -n XYZ -l 5000

execution started at timestamp 2006-11-15-09.51.37.046473
Using the default table space name USERSPACE1
Recommending indexes...
Recommending MQTs...
Recommending Multi-Dimensional Clusterings...
Found 6 user defined views in the catalog table
Found [4] candidate MQTs
Getting cost of workload with MQTs
I'm having trouble processing the following query, statement [1] in the
workload

Please check the syntax:
SQL: <select * from sysibm.sysdummy1>

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.

12 solutions were evaluated by the advisor

exiting with error code [-220]

i have already created explain and advise tables and verified that they
exist.
please help if someone experiences the same.
Nov 18 '06 #2
hi,

i have created explain tables and i verified that they exist.

On Nov 17, 9:01 pm, "Visu" <Visuba...@gmail.comwrote:
Make sure you have the explain tables for the user who invokes the
db2advis with proper permissions.

hello_db2 wrote:
hello,
db2advis gave me error like
db2advis -d ABC -s "select * from sysibm.sysdummy1" -m MIC -c USERSPACE1 -n XYZ -l 5000
execution started at timestamp 2006-11-15-09.51.37.046473
Using the default table space name USERSPACE1
Recommending indexes...
Recommending MQTs...
Recommending Multi-Dimensional Clusterings...
Found 6 user defined views in the catalog table
Found [4] candidate MQTs
Getting cost of workload with MQTs
I'm having trouble processing the following query, statement [1] in the
workload
Please check the syntax:
SQL: <select * from sysibm.sysdummy1>
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.
12 solutions were evaluated by the advisor
exiting with error code [-220]
i have already created explain and advise tables and verified that they
exist.
please help if someone experiences the same.- Hide quoted text -- Show quoted text -
Nov 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Matthew Dauphinee | last post: by
1 post views Thread by norab | last post: by
1 post views Thread by Anurag | last post: by
1 post views Thread by mandible | last post: by
reply views Thread by db2dbdba | last post: by
reply views Thread by suniltcs | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.