Re: High Water Mark Question

Posted in 1997

Nils Myklebust — Sun, 07 Dec 1997 21:32:58 GMT — source: Informix-list mailing list archive (1991-1998)

kponn@aol.com (KPonn) wrote: :Hi : :Our database was hung recently due to a long transaction. Our LTXHWM = 20 and :LTXHWM = 30 , which are pretty low. I am not sure why the database couldn't :rollback and recover from this long transaction. Anyone has any idea ? : :Thanks. :Keith May be because you have not set up a sufficient number of logs. Remember that the resolution of the percentages you give are never better than to the nearest number of actual logs. For some cases this may give you the problem you have. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org