Re: Long transaction

> From: Tony McCartan <100541.2445@CompuServe.COM> > Subject: Re: Long transaction > > On an Informix Online Administrator course Informix said that Support > can dial-in and add another logical log - obviating a restore > Hope we never need to do this. > We have the Low and High Watermark levels set at 85% and 90%. > I wonder if we should set hem much lower (like 1% - we have 6 logs files)? > -- > Tony McCartan > Tony Mc (UK) See the FAQ for a long-winded discussion. I still stand by my choice of somewhere around 50%. My latest thinking is that I can go to 50% and 60%, since it takes less log space to roll back than it does for the initial xaction. Pay particular attention, and heed the advice about how YOUR APPLICATION is running. My users cannot generate a long xaction, only my developers and administrators can, and then only thru SQL or some ad-lib code. Most of the long xactions we got into were the result of lengthy purges of many, many rows. We have since automated a purge routine which commits each and every row, and now we don't have that problem (as much.) __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|