Re: Best Practices

Yeah, I didn't try to quote the entire section of book -- we all know I'm
wordy enough without plagiarizing in my posts.  Right now, my pool size is
at the default 748 and my %reads yesterday are running 98% - 99%.  Today,
the numbers are more reasonable, but they still indicate that a change is
in order.

Thanks for the confirmation.

Patrick



                                                                           
             Chris Whisonant                                               
             <Chris.Whisonant@                                             
             comporium.com>                                             To 
             Sent by:                  Lotus Domino on the iSeries / AS400 
             domino400-bounces         <domino400@xxxxxxxxxxxx>            
             +ptrapp=nex-tech.                                          cc 
             com@xxxxxxxxxxxx                                              
                                                                   Subject 
                                       Re: Best Practices                  
             08/10/2006 07:15                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
              Lotus Domino on                                              
               the iSeries /                                               
                   AS400                                                   
             <domino400@midran                                             
                  ge.com>                                                  
                                                                           
                                                                           




That sounds about right. What's your current pool size? If you drop it and
the %reads goes below 95%, then you should raise it. Also, it's generally
recommended to raise or lower the buffer pool in increments of 10%.

Something else I found out is that if you don't define the buffer pool
size, then the defaults are as follows:

NSF Buffer Pool ? how size is set
Domino R5 - Set to 300 MB by default on iSeries
Domino 6 - Set to 748 MB by default on iSeries
Domino 7 - Set to 748 MB by default on iSeries

What to monitor when fine tuning
Non-database paging faulting = < 100 faults/processor
Database.BufferPool.PercentReadsInBuffer >= 95%
Database.DbCache.MaxEntries = 3 X BufferPool



Chris Whisonant
Comporium
Senior Mid-Range Systems Administrator
IBM eServer Certified Systems Expert - iSeries Technical Solutions V5R2
IBM Certified System Administrator - Lotus Notes and Domino 6/6.5
IBM Certified Associate Developer - Lotus Notes and Domino 6/6.5
803.326.7270

domino400-bounces+chris.whisonant=comporium.com@xxxxxxxxxxxx wrote on
08/09/2006 05:08:53 PM:

Related to an earlier question I floated through this forum, I've been
investigating how big was big enough on the NSF_BUFFER_POOL_SIZE

parameter.

On page 230 of the "Domino 6 for iSeries Best Practices" redbook, they

lay

out some variables to compare and they make the (sort of paraphrased)
statement that  "The NSF_BUFFER_POOL_SIZE is too large if
Database.Database.BufferPool.PerCentReadsInBuffer is between 94% and

99%,

but
Database.DbCache.MaxEntries is about 40% larger than
Database.DbCache.HighWaterMark."

A little later, it indicates that it's just right if the
Database.DbCache.MaxEntries is not more than 20% larger than
Database.DbCache.HighWaterMark.

So I'm taking this to mean that if Database.DbCache.MaxEntries is more

then

40% larger, I should consider adjusting the size of the pool down.  For
example, if Database.DbCache.MaxEntries is 1500 and
Database.DbCache.HighWaterMark is 900, the pool is larger than

necessary.

Does that sound right to you?

Thanks,
Patrick

_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.

NOTICE: This message contains information which may be confidential. If
the reader is neither the intended recipient nor a person responsible for
delivering the message to the intended recipient, you are notified that
any distribution, copying or retention of this communication is strictly
prohibited. If you have received this communication in error, please
notify us immediately by return e-mail, telephone or facsimile. Thank you.
_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.