473,224 Members | 1,410 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

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 3860
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Josh | last post by:
All: I use a content advisor restrict access to web sites. For some reason when I use the content advisor to only allow access to a site built on .NET, Internet Explorer crashes. However if I...
6
by: nek | last post by:
Greetings, Platform is DB2 V8.1, FP2 on W2K. Has anyone succeeded in invoking 'Configuration Advisor' from Control Center with DB2 running on W2K? I tried but failed with SQL22205C if it...
36
by: xixi | last post by:
hi, we are using db2 udb v8.1 on windows, i try to use the configuration advisor to get recommendation on the parameter setting, at first, i give the target memory for DB2 is 80% of the physical...
1
by: Jean-Marc Blaise | last post by:
Dear all, It would be nice if the Design advisor was not outputing all "unused indexes" of the whole database (10000 tables at least), when the workload is only using 4 tables. Why not...
0
by: yasaswi | last post by:
I tried is open Configuration Advisor both from the GUI on server and from Administation Client. On server it fails with SQL1224N error and on client it fails with SQL1013N and SQLSTATE=42705....
0
by: cjshea | last post by:
Hello Friends; I have a general question on Configuration Advisor, as I get to know it better I may have more focused questions. I have a feeling that the Advisor may assume that there is only...
4
by: datapro01 | last post by:
Running DB2 8.1.1 on AIX 5.1 When I run the design advisor on selected sql I am getting 'recommendations' for indexes which already exist. I don't understand why this is happening. They are...
3
by: UnixSlaxer | last post by:
Hello, I am using DB2 UDB v.8.2, with TPC-H 1GB database. When I use the design advisor, and set a disk space limit of 100 MB, the design advisor does not recommend anything. db2advis -l...
0
by: Okonita | last post by:
Hello community, My environment is DB2 UDB v8.2 LUW. I am experiencing a vexing problem with using my DB2 Design Advisor. I submitted a SQL script to Advisor for index recommendation and I am...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.