Re: to many logical logs: cannot restart database

Posted in 1996

Paul McGuire — Tue, 07 May 1996 11:18:49 GMT — source: Informix-list mailing list archive (1991-1998)

ematic@iafrica.com (Paul Schreuder) wrote: >Hi Fred >I have a similar problem where one transaction results in a long transaction >situation where one transactions spans all the logs. Once this occured the only >way to recover is to restore from backup. (Hopefully resent) The default value the long transaction settings are too high in version 5. In version 7 Informix have changed them to :- LTXHWM 50 # Long transaction high water markpercentage LTXEHWM 60 # Long transaction high water mark (exclusive) Regards Paul McGuire