Re: Error: -458 Long transaction aborted.

Posted in 1997

Neil — 16 Sep 1997 01:04:29 -0700 — source: Informix-list mailing list archive (1991-1998)

In article <5vkb3l$nvr@jethro.Corp.Sun.COM>, yoga@peacetime.corp.sun.com says... > >Hi Folks, > >We really need a help here from you, experienced DBAs. > >We have ODS 5.0.2 server and we are receiving error# 458 on somewhat >long transaction. During such transcations, I have been monitoring the >log files and only 6-8 out of 16 are filled up and we are getting this >nasty message. I also monitored the available lock but it is also not touching >limit too. > >Is something I am missing?? Have a look at your TBCONFIG file, specifically the LTXHWM and LTXEHWM parameters. If LTXHWM is set to (say) 50, then you will only half of your available logs filled before a rollback is issued. (See "Informix OnLine Administrator's Guide version 5.0 page 1-35). Neil Truby Chase Manhattan Bank Bournemouth, UK ntruby@chase.com