ADSM-L

Database cache percentage

2000-01-10 16:10:11
Subject: Database cache percentage
From: William R Zehnder <wzehnder AT JCPENNEY DOT COM>
Date: Mon, 10 Jan 2000 15:10:11 -0600
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,
Cordially,

Bill Zehnder
ITCC
972-431-8733  Fax 972-531-8733
<Prev in Thread] Current Thread [Next in Thread>