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
> >>>
|
