Hmmm.....I think it's supposed to be "unlimited" at 3.7, but now  that you
mention it, I seem to recall that there might be a limitation that we ran in
to before too.  I'll see if I can find out.

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
> >>>Keith A. Crabb
> >>>Sent: Monday, January 10, 2000 4:52 PM
> >>>To: ADSM-L AT VM.MARIST DOT EDU
> >>>Subject: Re: Database cache percentage
> >>>
> >>>
> >>>
> >>>
> >>>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
> >>>> >>>
> >>>