Long Transaction Aborted

Posted in 1999

Simon Leigh — Wed, 7 Jul 1999 10:31:52 +0100 — source: Informix-list mailing list archive (1991-1998)

Apparently this is caused by an incorrect setting in the database can anyone tell me what it is?? Thanks Simon

↪ replying to Simon Leigh

Yuri Dovgart — Wed, 07 Jul 1999 10:45:08 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7lv6fs$e89$1@uranium.btinternet.com>, "Simon Leigh" <simon.leigh@btinternet.com> wrote: > Apparently this is caused by an incorrect setting in the database > can anyone tell me what it is?? Percentage of logical logs occupied by the single transaction exceeds the number in the LTXHWM param. Increase number or size of your logical logs, if this happened frequently. -- 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.

↪ replying to Yuri Dovgart

Bruce Robertson — Wed, 7 Jul 1999 14:50:28 +0100 — source: Informix-list mailing list archive (1991-1998)

But increase it too much and you could have problems. Onour site we have a high water mark of 40%. So if the transaction uses more than 40% of logical log space then you get long transaction aborted. If it is too high and all the logs get filled it requires someone from Informix to dial in and fix it ( Well on our Infx Online 5 anyway ). Yuri Dovgart <y_dovgart@tci.ukrtel.net> wrote in message news:7lvb3j$9df$1@nnrp1.deja.com... > In article <7lv6fs$e89$1@uranium.btinternet.com>, > "Simon Leigh" <simon.leigh@btinternet.com> wrote: > > Apparently this is caused by an incorrect setting in the database > > can anyone tell me what it is?? > > Percentage of logical logs occupied by the single transaction exceeds > the number in the LTXHWM param. Increase number or size of your logical > logs, if this happened frequently. > > -- > 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. >

↪ replying to Bruce Robertson

Yuri Dovgart — Wed, 07 Jul 1999 15:10:49 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7lvlrp$hbo$2@uranium.btinternet.com>, "Bruce Robertson" <br@leith.walk.co.uk> wrote: > But increase it too much and you could have problems. > Onour site we have a high water mark of 40%. So if the transaction uses more > than 40% of logical log space then you get long transaction aborted. If it > is too high and all the logs get filled it requires someone from Informix to > dial in and fix it ( Well on our Infx Online 5 anyway ). Bruce, I mean increase logs SIZE or logs NUMBER, not LTXHWM. Increasing number or size of your logs will give you ability to have bigger transactions with same LTXHWM. About values of LTXHWM and LTXEHWM - Informix told, that with default values (50 and 60 respectively) you will never find yourself in situation, when your system hangs because of no log space. Even if you in this trap - just do point-in-time restore according to the begin time of the long transaction, or restore without logical recovery. There are some scenarious - I can tell you through email, if you want me to. -- 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.