hi,
in our installation we have 2GB RAM, BUFFPOOLSIZE=65536,LOGPOOLSIZE=512
With these settings we have a DB-CACHE-HIT-PCT between 98.5% and 99.5% (we
reset the values every day).
Best regards
Chris
> -----Ursprüngliche Nachricht-----
> Von: Pothula S Paparao [SMTP:9pothula AT SG.IBM DOT COM]
> Gesendet am: Dienstag, 27. November 2001 08:04
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: logpool size for 2 gb RAM
> Wichtigkeit: Hoch
>
> how much do i have to set the value for LOGPOOLSIZE for 2gb RAM .
> my buffpoolsize is already set to 262144. even then, my db cache hit pct
> is
> well below 99% i,e. 96%
>
>
> thanks in advance.
> regards
> sreekumar.
|