db2 conf. on HP UX problem

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

    db2 conf. on HP UX problem

    HP UX 11i, db2 v8.2

    kernel parameters of HPUX such as shmmax had been changed to MEM*0.9, about
    3.6g.

    when I create a partitioned db(4 partitions)on the server, warning raised
    saying that not enough memory for bufferpool use. when I lower the user of
    bufferpool to only 8000(8k page),error vanished.

    4G memory in total, but it seems that I can only use very little of them.
    the HP UX is 64bit, db2 instance is 32 bits.

    can you help me on the very problem? thank you~~


    Tags: None
    • Mark A
      #2
      Re: db2 conf. on HP UX problem

      "Hardy" <WelcomeNoSpam@ acc.com> wrote in message
      news:csaqo9$1qi n$1@mail.cn99.c om...[color=blue]
      > HP UX 11i, db2 v8.2
      >
      > kernel parameters of HPUX such as shmmax had been changed to MEM*0.9,[/color]
      about[color=blue]
      > 3.6g.
      >
      > when I create a partitioned db(4 partitions)on the server, warning raised
      > saying that not enough memory for bufferpool use. when I lower the user of
      > bufferpool to only 8000(8k page),error vanished.
      >
      > 4G memory in total, but it seems that I can only use very little of them.
      > the HP UX is 64bit, db2 instance is 32 bits.
      >
      > can you help me on the very problem? thank you~~
      >[/color]
      You can only have about 1GB bufferpools for 32 bit DB2 instances on HP-UX.
      This number varies by OS, and allows slightly more for AIX and Solaris. The
      exact number seems to be a bit of voodoo.

      I have no idea why you have to go to only 8000 8K pages however. I would
      open a problem with IBM support.


        Comment

        • Hardy
          #3
          Re: db2 conf. on HP UX problem

          en, I have open a PMR and I'll paste the final result when it's over. thank
          you, Mark:)

          "Mark A" <nobody@nowhere .com> дÈëÓʼþ
          news:WvudnUB3Q5 9MtnTcRVn-oQ@comcast.com. ..[color=blue]
          > "Hardy" <WelcomeNoSpam@ acc.com> wrote in message
          > news:csaqo9$1qi n$1@mail.cn99.c om...[color=green]
          > > HP UX 11i, db2 v8.2
          > >
          > > kernel parameters of HPUX such as shmmax had been changed to MEM*0.9,[/color]
          > about[color=green]
          > > 3.6g.
          > >
          > > when I create a partitioned db(4 partitions)on the server, warning[/color][/color]
          raised[color=blue][color=green]
          > > saying that not enough memory for bufferpool use. when I lower the user[/color][/color]
          of[color=blue][color=green]
          > > bufferpool to only 8000(8k page),error vanished.
          > >
          > > 4G memory in total, but it seems that I can only use very little of[/color][/color]
          them.[color=blue][color=green]
          > > the HP UX is 64bit, db2 instance is 32 bits.
          > >
          > > can you help me on the very problem? thank you~~
          > >[/color]
          > You can only have about 1GB bufferpools for 32 bit DB2 instances on HP-UX.
          > This number varies by OS, and allows slightly more for AIX and Solaris.[/color]
          The[color=blue]
          > exact number seems to be a bit of voodoo.
          >
          > I have no idea why you have to go to only 8000 8K pages however. I would
          > open a problem with IBM support.
          >
          >[/color]


            Comment

            Previous template Next
            Working...