Hi Larry,
Can you try to run the advisor from the command line?
Example:
$ db2 connect to db
$ db2 autoconfigure using <> ... apply none
Try this to start and see if you get the recommendation display screen.
Then,
$ db2 \? autoconfigure to get all the options for the command and issue
it with the "apply db and dbm" clause.
Mick
Larry Trutter wrote:
Environment:
Windows 2000
DB2 Version 8 fixpack 4
I am attempting to use DB2 Configuration Advisor. But when I get to
the end of that wizard process (sequentially - I went through all the
steps and did not skip any)and "Review the performance configuration
recommendations" screen displayed the all current values and all new
values to be exactly the same every time. For a specific example, I
changed the memory usage percentage and the recommended buffer pool
was never changed. Obviously, there is something wrong with the
Configuration Advisor.
Another situation is that when I start configuration advisor and then
skip all of the steps to go directly to "9. Schedule" and click on
"Run now" to get to the result screen, the results screen is able to
display some recommended values that are different from the current
values. So basically, the Configuration Advisor "works" ONLY if you
use the default parameters(i.e. memory usage, mixed transaction,
workload type, etc.) provided by the Configuration Advisor. Obviously
this does not work for us.
DB2 autoconfigure seems to be working like it is supposed to. So the
Configuration Advisor is broken.
Will this issue be resolved in the upcoming fixpack 5?
Larry Trutter
Lead Developer
