Well, well, well!
It's Robert Yazujian! Hehe. How have you been?
Tuning the catalog cache
Catalog cache hit ratio can be calculated by using the following
formula:
(1 - (Catalog cache inserts / catalog cache lookups)) * 100
A smaller hit ratio is the indication that the catalogcache_sz should be
increased.
http://www.ibm.com/developerworks/db2/library/techarticle/0205parlapalli
/0205parlapalli.html
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Robert Yazujian
[mailto:db2udbdba-ezmlmshield-x75244385.[Email address protected]
Sent: Tuesday, May 06, 2008 4:06 PM
To: LazyDBA Discussion
Subject: Catalog Cache Hit Ratio
Good afternoon,
I was wondering if someone could provide some advise on the
size of the catalogcache_sz parameter. We are running DB2 V8.2 on an
Intel LINUX box utilizing PeopleSoft as the software package. We have 8
gig of memory on the box with quad CPUs. The size of our catalog cache
is set to 800 right now. This was a recommendation from a consultant but
as I monitor this database, it appears the average catalog cache hit
ratio is between 80 and 89 percent most of the time. In a PeopleSoft
environment I do not know if you can achieve a 90 percent and better hit
ratio but will increasing the size of the catalog cache help? What
increments would be recommended in increasing the size? This might not
be enough information for someone to make recommendation on but if there
is anyone out there running PeopleSoft on DB2 I would like to hear from
them.
Any help would be appreciated. Bufferpool, index and package
cache ratios all look good in the 90 percent tile.
Thanks,
Yaz
Robert J. Yazujian III
Database Manager
Illinois Central College
Technology Services L-143
Office: 309-694-5486
Fax: 309-694-8995
[Email address protected] <mailto:[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page