db2advis giving trouble

[hello_db2]

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.

[Visu]

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.

[hello_db2]

hi,

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

On Nov 17, 9:01 pm, "Visu" <[e-mail]:

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 -