Re: Recovery

In article <1inm5vINN3gm@emory.mathcs.emory.edu> unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah) writes: >Welcome to the world of STUCK FAST RECOVERY ... >I have faced this problem on more than one occassion and I have been asked to >wait for version 5.0 where HIGHT_WATER settings can solve this problem. > >Bharat. hi bharat, i don't know the version of the engine you have, but if you have 4.10 you can edit the tbconfig file to include the two long transaction water marks - LTXHWM and LTXEHWM which are commonly set to 75 and 80 respectively (percentage values). LTXHWM is the Long Transactio High Water Mark - set to 75% which tells online to roll transactions back when the logs are 75% full. LTEXHWM is the Long Transaction Exclusive High Water Mark - set to a value > LTXHWM, usually 80% , which when reached, gives "exclusive" access of the logical logs to the transaction currently being rolled back. just a brief explanation but i hope it helps. regards, ramesh. > >======================================================================== >Bharat Shah Voice: (508)-663-7570 >Unifi Communications Corp. Fax: (508)-663-7543 >4 Federal St, Billerica, Mass 01821, USA uunet!bharat@unifi.com >========================================================================