Long Transaction Detected message

Posted in 1999

Susan Elliott (ISG) — Fri, 10 Sep 1999 12:34:19 +1200 — source: Informix-list mailing list archive (1991-1998)

Howdy folks, We recieved "Long transaction 'detected' " in our online.log last night, I have never seen this before. I have searched FAQ's and the manuals for information about it, to no avail. Could someone please: A) explain the difference between a "Long tranaction aborted" & "Long transaction 'detected' " B) Advise whether I should be concerned about this message turning up ??? Cheers Suze. Susan Elliott ______________________ Host Team Leader Information Services Group Concrete Group * (09) 520 8608 * susane@fclcis.co.nz

↪ replying to Susan Elliott (ISG)

Yuri Dovgart — Fri, 10 Sep 1999 06:34:44 GMT — source: Informix-list mailing list archive (1991-1998)

> > Could someone please: > A) explain the difference between a "Long tranaction aborted" & "Long > transaction 'detected' " 'detected' means, that percentage of logical logs, occupied by single transaction equal to or higher than LTXHWM configuration param. 'aborted' means, that rollback of this transaction completed sucesfully. > B) Advise whether I should be concerned about this message turning up ??? If this message appears too often in your log, increase total logical logs space. Use 'onparams' to add more logical logs. Also, you can change LTXHWM and LTXEHWM params, but I don't recommend you doing so. -- With best regards, Yuri Dovgart, SAP R/3, Informix consultant, "Telecominvest" company. E-mail y_dovgart@tci.ukrtel.net Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.