DB2 Configuration Advisor issue

[Larry Trutter]

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

[Mick Legare]

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

[Larry Trutter]

Yes, I am able to run the advisor from the command line. Just pointing
out that the GUI-based Configuration Advisor is not working.

-Larry Trutter

Mick Legare <ml*****@no-spam-ca.ibm.com> wrote in message news:<40***************@no-spam-ca.ibm.com>...

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

[Mark A]

"Larry Trutter" <st***********@hotmail.com> wrote in message
news:5f**************************@posting.google.c om...

Yes, I am able to run the advisor from the command line. Just pointing
out that the GUI-based Configuration Advisor is not working.

-Larry Trutter

Can someone from IBM please comment on whether this a known problem?