Greetings, I'm playing around with db2advis and when I try -m C option
it says ERROR <SQLCODE = 0>. Any ideas what might be wrong anyone?
Thanx in advance
/Lennart
[db2inst1@db2-00 ~/lelle]$ uname -a
Linux db2-00 2.4.21-20.ELsmp #1 SMP Wed Aug 18 20:46:40 EDT 2004 i686
i686 i386 GNU/Linux
[db2inst1@db2-00 ~/lelle]$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.0.72", "s040914", "MI00086", and
FixPak "7".
Product is installed at "/opt/IBM/db2/V8.1".
[db2inst1@db2-00 ~/lelle]$ db2advis -d presdb -i aa.sql -o db2adv1.out
-m C
Using user id as default schema name. Use -n option to specify schema
execution started at timestamp 2005-01-04-23.32.49.912215
found [1] SQL statements from the input file
Recommending Multi-Dimensional Clusterings...
total disk space needed for initial set [ 0.035] MB
total disk space constrained to [ 363.227] MB
Note: MDC selection in the DB2 Design Advisor requires the target
database
to be populated with a data sample. This sample is used for
estimating
the number and density of MDC cells in any MDC solution that the
Design Advisor will recommend. If your database is empty the
Design Advisor will not recommend MDC.
Prioritizing Multi-dimensional Clustering candidate tables...
Multi-dimensional Clustering candidate tables, in priority sequence:
Table 0: PICKED_COURSE_OFFERING_MEASURE,
number of pages 397,
block size 16
Table 1: PERSON,
number of pages 11289,
block size 16
Table 2: PICKED_COURSE_OFFERING,
number of pages 42832,
block size 16
Table 3: APPLICATION,
number of pages 5611,
block size 16
There are 4 candidate tables considered for Multi-dimensional
Clustering conversion
Searching the multidimensional space for solutions for
PICKED_COURSE_OFFERING_MEASURE...
Error <SQLCODE = 0>
18 solutions were evaluated by the advisor
exiting with error code [-440]