Re: How to kill a long transaction?

In article <338AF18B.2789@uninet.co.cn>, Marlin <adparks@uninet.co.cn> wrote: >Hi, > I am now using Informix Dynamic OnLine 7.x on a HP-UX server, can you >tell me how I can detect and kill a long transaction? > >Thans you very much! OL usually takes care of the long transaction very well - i.e it detects and aborts a long transaction automatically. You can help by doing the following : 1. Set LTXHWM and LTXEHWM appropriately - 50 and 60 are usually ok. 2. Keep the number of log files above 10 - Informix attempts to detect long trxs only when switching logs. 3. Investigate your applications for potential creators of long trxs. HTH. ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------