doubt about parameters

Posted in 2012

wanderlei.barboza — Tue, 08 May 2012 16:38:13 — source: IIUG Forums & Mailing Lists

I wonder what the ideal configuration for an IBM machine with 01TB P7-780 Ram for the parameters and PHYSBUFF and LOGBUFF with replication and without replication thank you very much Wanderlei - Intera Consultoria (55+11) 6707-3778

↪ replying to wanderlei.barboza

Art Kagel — Tue, 08 May 2012 16:50:09 — source: IIUG Forums & Mailing Lists

If your databases are all UNBUFFERED LOG (my preference for safety) then the logical log buffer size should be about 2x - 3x the size of a typical transaction depending on the number of concurrent transactions you expect. If all of your databases are BUFFERED LOG then the size of the logical log buffer will depend on how much data you are willing to risk if the server crashes with a committed transaction that's still in the log buffer and hasn't been flushed to disk yet versus how much extra speed you want over having made the database UNBUFFERED. That's a trade off that's your call. Physical log buffer, similarly, should be fairly small so that relatively little of the pre-images are at risk during a hard crash. Your call, I usually set this between 32K & 64K. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, May 8, 2012 at 12:38 PM, wanderlei.barboza < wanderlei.barboza@interaconsultoria.com.br> wrote: > I wonder what the ideal configuration for an IBM machine with 01TB P7-780 > Ram > for the parameters and PHYSBUFF and LOGBUFF with replication and without > replication > > thank you very much > > Wanderlei - Intera Consultoria > (55+11) 6707-3778 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340661abee0a04bf892d6e