468,241 Members | 1,420 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

DB2 Configuration Advisor issue

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
Nov 12 '05 #1
3 3599
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


Nov 12 '05 #2
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

Nov 12 '05 #3
"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?
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Josh | last post: by
6 posts views Thread by nek | last post: by
1 post views Thread by Jean-Marc Blaise | last post: by
reply views Thread by yasaswi | last post: by
reply views Thread by cjshea | last post: by
4 posts views Thread by datapro01 | last post: by
3 posts views Thread by UnixSlaxer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.