ADSM-L

Re: Database cache percentage

2000-01-11 04:26:08
Subject: Re: Database cache percentage
From: "Mauro M. TINELLI" <Mauro.TINELLI AT ST DOT COM>
Date: Tue, 11 Jan 2000 10:26:08 +0100
Keith,

IBM sold me an additional 1GB of RAM for my NSM3466 (H50), and I'm
waiting for the installation. It's going to be a 2GB box, I let you know.

Mauro, STM
>
>
> Is it really unlimited?  I'm running ADSM 3.1.2.42 on AIX 4.3.2 and I
had a
> problem when I defined more than 1024MB for the buffpoolsize (actually
1,256MB
> was the number I used).  The ADSM server actually died with an out of
memory
> error.  That's not a real error though, I have 5GB in the box and it
only runs
> ADSM, the server process only made it to about 1.3-1.4GB before it
died.  I
> didn't really follow up since I was changing it from 756MB and 256MB
more seemed
>
> to do the trick for now.  Is anybody using more than 1GB for the
buffpoolsize?
>
>
>
>
>
>
>
>
> "Laura G. Buckley" <buckley AT STORSOL DOT COM> on 01/10/2000 05:05:53 PM
>
> Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
>
>
>
>
>
>
>  To:      ADSM-L AT VM.MARIST DOT EDU
>
>  cc:      (bcc: Keith A Crabb/SS/HouInd)
>
>
>
>  Subject: Re: Database cache percentage
>
>
>
>
>
>
>
>
>
> Bill,
>
> Increasing your buffpoolsize should increase your cache hit pct.
> Technically, the maximum size of your buffer pool is amount of
available
> virtual memory on your system.    Be sure to restart your ADSM server
after
> increasing your bufpoolsize.
>
> Laura G. Buckley
> Storage Solutions Specialists, Inc.
> PO Box 51313
> Colorado Springs CO 80949-1313
> (719)531-5133, FAX (719)260-5991
> buckley AT storsol DOT com
> www.storsol.com
>
>
> > >>>-----Original Message-----
> > >>>From: ADSM: Dist Stor Manager
> > >>>[mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> > >>>William R Zehnder
> > >>>Sent: Monday, January 10, 2000 2:10 PM
> > >>>To: ADSM-L AT VM.MARIST DOT EDU
> > >>>Subject: Database cache percentage
> > >>>
> > >>>
> > >>>I've got a database cache problem.  My cache hit
> > >>>percentage is way too
> > >>>low -
> > >>>
> > >>>     Page Size (bytes): 4,096
> > >>>    Total Usable Pages: 7,827,456
> > >>>            Used Pages: 6,047,439
> > >>>              Pct Util: 77.3
> > >>>         Max. Pct Util: 77.7
> > >>>      Physical Volumes: 12
> > >>>     Buffer Pool Pages: 32,768
> > >>> Total Buffer Requests: 1,033,521,610
> > >>>        Cache Hit Pct.: 79.88
> > >>>       Cache Wait Pct.: 0.00
> > >>>   Backup in Progress?: No
> > >>>
> > >>>The dsmserv.opt file has the following -
> > >>>
> > >>> BUFPoolsize 131072
> > >>>
> > >>>The bufpoolsize was set months ago.  Are there changes I
> > >>>can make to get
> > >>>the percentage in the 99% range?  The server level is
> > >>>3.1.2.40 running
> > >>>on AIX 4.3.2 with 2 gb's of main memory.
> > >>>
> > >>>Thanks.
> > >>>
> > >>>--
> > >>>Cordially,
> > >>>
> > >>>Bill Zehnder
> > >>>ITCC
> > >>>972-431-8733  Fax 972-531-8733
> > >>>
>
<Prev in Thread] Current Thread [Next in Thread>