ADSM-L

Re: Database Specs

2015-10-04 17:13:42
Subject: Re: Database Specs
From: Malbrough, Demetrius [mailto:DMalbrough AT TTIINC DOT COM]
To: ADSM-L AT VM.MARIST DOT EDU
If you are going to increase the BUFPoolsize parameter make sure you do it
based on
the amount of System Memory (MB). 'An optimal setting for the database
buffer pool is one in which the cache hit percentage is greater than or
equal to 98%. If you have enough memory, increase in 1MB increments. A cache
hit percentage greater than 99% is an indication that the proper BUFPoolsize
has been reached. While increasing BUFPoolsize, care must be taken not to
cause paging in the virtual memory system. Monitor system memory usage to
check for any increased paging after the BUFPoolsize change. (Use the RESET
BUFP command to reset the cache hit statistics.)'

Regards,

Demetrius Malbrough
UNIX/TSM Administrator




<Prev in Thread] Current Thread [Next in Thread>