DB2 Configuration Advisor issue

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Larry Trutter
    #1

    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
    Tags: None
    • Mick Legare
      #2
      Re: DB2 Configuration Advisor issue

      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:
      [color=blue]
      > 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[/color]

        Comment

        • Larry Trutter
          #3
          Re: DB2 Configuration Advisor issue

          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 <mlegare@no-spam-ca.ibm.com> wrote in message news:<4006DDF0. AFD3AFD1@no-spam-ca.ibm.com>...[color=blue]
          > 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:
          >[color=green]
          > > 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[/color][/color]

            Comment

            • Mark A
              #4
              Re: DB2 Configuration Advisor issue

              "Larry Trutter" <stargazerzero@ hotmail.com> wrote in message
              news:5f2878fa.0 401200844.394e8 1f2@posting.goo gle.com...[color=blue]
              > 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
              >[/color]
              Can someone from IBM please comment on whether this a known problem?


                Comment

                Previous template Next
                Working...