hello all,

im trying to configure what should i set my min and max number or
servers.

i currently have 12 cpu attached to a SAN..

Thanks for your help
pinoy

On Mar 11, 4:36*pm, pinoy2ser <pinoy2...@gmail.com> wrote:
> hello all,
>
> * * im trying to configure what should i set my min and max number or
> servers.
>
> i currently have 12 cpu attached to a SAN..
>
> Thanks for your help
> pinoy

doesnt directly answer your question, but set maxreqs high and make
sure you have patch 1IZ03260 installed or db2 can crash.

as long as you are not very tight on cpu and memory, set max servers
high as well.

On Mar 12, 8:37*am, a...@mail.com wrote:
> On Mar 11, 4:36*pm, pinoy2ser <pinoy2...@gmail.com> wrote:
>
> > hello all,
>
> > * * im trying to configure what should i set my min and max number or
> > servers.
>
> > i currently have 12 cpu attached to a SAN..
>
> > Thanks for your help
> > pinoy
>
> doesnt directly answer your question, but set maxreqs high and make
> sure you have patch 1IZ03260 installed or db2 can crash.
>
> as long as you are not very tight on cpu and memory, set max servers
> high as well.

hi,

is this a DB2 patch or an AIX patch?
i have 12 cpu with 16ghz and 13g memory.
im also running db2 8.2
now i set the min=150 max=300

pinoy

pinoy2ser wrote:

> now i set the min=150 max=300

I'm pretty sure that is not a good setup, since you will end up with a
minimum of 150 * 12 aioservers. (pstat -A | grep aios |wc -l)

From the AIX performance tuning guide:
minservers: Making this a large number is not recommended, because each
process takes up some memory. Leaving this number small is acceptable in
most cases because AIO will create additional kprocs up to maxservers as
needed.

maxservers: The value should be the same as the number of expected
concurrent AIO requests.

A good starting point for MAXSERVERS is (Nr of disks on system * 10), or
1000 - whichever is smallest, but this formula came before the time of
storage subsystems.

You should also increase maxreqs to a higher range e.g. 16384-32768.

I still use it but I rely on pstat to monitor the number of aioservers
that are in use and increase maxservers accordingly if I see that the in
use figure approaches maxservers.

Niel