IDS Forum

Re: Long transaction problem!!

Posted By:
Date:

--0__=85256CFC004A62348f9e8a93df938690918c85256CFC004A6234
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: quoted-printable



Hi Luis,

I wrote this script some time ago to do what you are requesting. I've
enclosed it. You may use it at your own risk. I disclaim responsibili=
ty
for anything that may go wrong. Please note that I've been using this =
for
years and nothing has gone wrong.

(See attached file: ltx.db)

Before using it, you will need to change some lines at the top of the
script to match your environment:

Change this to point to a script that sets up your environment to conne=
ct
to the database, or just substitute the environment variables in it's
place:

. $HOME/.dbenv_`hostname`.sh

Change the email addresses to go to whom you want to be notified:

SENDTO=3D"dba1@mail.box 0000000000@mobile.att.net"

Change this to indicate at what percentage you would like long transact=
ion
notifications to start. In SAP, they set LTXEHWM to 80 and LTXHWM to 7=
0.
As you know, Informix attempts to abort a transaction when it reaches t=
he
LTXWHM percentage. I recommend setting the LTXWARN script variable bel=
ow
this value.

LTXWARN=3D50

Once these changes are made, ftp the script to the box with the informi=
x
instance, then make it an informix executable with the following comman=
ds:

chown informix:informix ltx.db
chmod 700 ltx.db

Finally, add this or similar line to your contab file so monitoring can=

take place.

0,15,30,45 * * * * /location/of/the/script/ltx.db >> /dev/null

Whala, now you can monitor long transactions before they abort. The sc=
ript
will provide you with detailed information so that you can manually abo=
rt
(if necessary) long running transactions before they pose harm to your
system.

Happy days ahead,
-Tim




=
=20
"luis.lopez0... =
=20
." To: ids@iiug.org =
=20
<luis.lopez02@c cc: =
=20
fe.gob.mx> Subject: Long transaction=
problem!! [839] =20
Sent by: =
=20
forum.subscribe =
=20
r@iiug.org =
=20
=
=20
=
=20
04/01/2003 =
=20
09:19 PM =
=20
=
=20
=
=20




Today I had a problem with a Long transaction that blocked production d=
b
for 20 minutes, Actually I detect de LTX with the ALARMPROGRAM, but I w=
ould
like to detect before this appear in order to prevent it, transactions =
to
be candidates for a Long transaction.

Does anyone know how can I do that.

Thanks in advance.

Luis Arturo L=F3pez Caballero
Proyecto ASARE - Modulo Base
Mexico D.F.
Tel. 01(55)52294400 Ext. 85705









=

--0__=85256CFC004A62348f9e8a93df938690918c85256CFC004A6234
Content-type: application/octet-stream;
name="=?iso-8859-1?Q?ltx.db?="
Content-Disposition: attachment; filename="=?iso-8859-1?Q?ltx.db?="
Content-transfer-encoding: base64

IyEvdXNyL2Jpbi9rc2ggLWUNCg0KIyBUZXN0ZWQgd2l0aCBJRFMgNy4yeCBhbmQgNy4zeA0KDQoj
IHNldHVwIGluZm9ybWl4IGVudmlyb25tZW50IHZhcmlhYmxlcw0KLiAkSE9NRS8uZGJlbnZfYGhv
c3RuYW1lYC5zaA0KDQpTRU5EVE89ImRiYTFAbWFpbC5ib3ggZGJhMkBtYWlsLmJveCIgICAgICMg
c2VuZCB3YXJuaW5nIG1lc3NhZ2VzIHRvIHRoZW0NCkxUWFdBUk49NTAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgIyBwZXJjZW50YWdlIHdoZW4gdG8gc3RhcnQgd2FybmluZw0KDQojIFRo
ZSBkYXRhYmFzZSAoJElORk9STUlYRElSL2V0Yy8kT05DT05GSUcpIGhhcyB0aGUgZm9sbG93aW5n
IGluaXRpYWxpemF0aW9uIHBhcmFtZXRlcnM6DQojICAgTFRYSFdNICAtIHBlcmNlbnRhZ2Ugb2Yg
bG9ncyBzcGFubmVkIChwZXIgdHgpIHdoZW4gYSByb2xsYmFjayBpcyBlbmZvcmNlZA0KIyAgIExU
WEVXSE0gLSBwZXJjZW50YWdlIG9mIGxvZ3Mgc3Bhbm5lZCAocGVyIHR4KSB3aGVuIGFuIGV4Y2x1
c2l2ZSByb2xsYmFjayBpcyBlbmZvcmNlZA0KIw0KIyBUaGlzIHNjcmlwdCBhZGRzIGhhcyB0aGUg
Zm9sbG93aW5nIGluaXRpYWxpemF0aW9uIHBhcmFtZXRlcnM6DQojICAgTFRYV0FSTiAtIHBlcmNl
bnRhZ2Ugb2YgbG9ncyBzcGFubmVkIChwZXIgdHgpIHdoZW4gYSB3YXJuaW5nIHNob3VsZCBiZSBp
c3N1ZWQNCiMgICBTRU5EVE8gIC0gbGlzdCBvZiBlbWFpbC9wYWdlciBhZGRyZXNzZXMgdG8gc2Vu
ZCBhIG1lc3NhZ2Ugd2hlbiBhbiBldmVudCBvY2N1cnMNCg0KIyBjdXJyZW50IGxvZyBhbmQgbnVt
YmVyIG9mIGxvZ3MNCnNldCBgb25zdGF0IC1sfGF3ayAnDQp7DQogIGlmKCQxPT0iYWRkcmVzcyIp
DQogICAgZ3JhYj0xOw0KICANCiAgZWxzZSBpZihncmFiICYmICgkNH4iXlswLTldWzAtOV0qJCIp
KQ0KICB7DQogICAgbmxvZ3M9JDI7DQogICAgaWYoc3Vic3RyKCQzLDUsMSk9PSJDIikNCiAgICAg
IGNsb2c9JDQ7DQogIH0NCn0NCkVORHtwcmludGYoIiVkICVkIixjbG9nLG5sb2dzKTt9J2ANCg0K
Q0xPRz0kMSAgICAgICAgIyBjdXJyZW50IGxvZw0KTkxPR1M9JDIgICAgICAgIyBudW1iZXIgb2Yg
bG9ncw0KDQojIGxvbmcgdHJhbnNhY3Rpb24gaGlnaCB3YXRlciBtYXJrcyANCnNldCBgb25zdGF0
IC1jfGdyZXAgTFRYfGF3ayAtdiBubG9ncz0kTkxPR1MgLXYgbHR4d2Fybj0kTFRYV0FSTiAnDQp7
DQogIGlmKCQxPT0iTFRYSFdNIikNCiAgICBod209KCQyKm5sb2dzKS8xMDA7DQogIGVsc2UgaWYo
JDE9PSJMVFhFSFdNIikNCiAgICBlaHdtPSgkMipubG9ncykvMTAwOw0KfQ0KRU5Ee3ByaW50Zigi
JWQgJWQgJWQiLChsdHh3YXJuKm5sb2dzKS8xMDAsaHdtLGVod20pO30nYA0KDQpXQVJOPSQxICAg
ICAgICAjIHdhcm5pbmcgbGV2ZWwNCkhXTT0kMiAgICAgICAgICMgaGlnaCB3YXRlciBtYXJrDQpF
SFdNPSQzICAgICAgICAjIGV4Y2x1c2l2ZSBoaWdoIHdhdGVyIG1hcmsNCg0KIyB0cmFuc2FjdGlv
bnMNCm9uc3RhdCAteHxlZ3JlcCAtdiAiYWN0aXZlfGFkZHJlc3MifGF3ayAtdiBjbG9nPSRDTE9H
IC12IG5sb2dzPSROTE9HUyAtdiB3YXJuPSRXQVJOIC12IGh3bT0kSFdNIC12IGVod209JEVIV00g
Jw0Kew0KICBpZihORj09NyAmJiAoJDV+Il5bMC05XVswLTldKiQiKSAmJiAkNSE9MCkgICMgbG9n
IGlzIGEgbnVtYmVyIG90aGVyIHRoYW4gMA0KICB7DQogICAgc3RhdD1zdWJzdHIoJDIsMywxKTsg
ICMgQi1iZWdpbiB3b3JrLCBDLWNvbW1pdCwgUi1yb2xsYmFjaywgSC1odWVyaXN0aWMgcm9sbGJh
Y2sgDQogICAgdXRoZD0kMzsgICAgICAgICAgICAgICMgdXNlcnRocmVhZA0KICAgIHR4PSQxOyAg
ICAgICAgICAgICAgICAjIHRyYW5zYWN0aW9uIElEIC0tIGNvcnJlbGF0ZWQgd2l0aCB0eCBudW1i
ZXIgd2hlbiB0cmFuc2FjdGlvbiBhYm9ydHMNCiAgICBzcGFubmVkPWNsb2ctJDU7ICAgICAgIyBu
dW1iZXIgb2YgbG9ncyBzcGFubmVkDQogICAgbG9ja3M9JDQ7ICAgICAgICAgICAgICMgbnVtYmVy
IG9mIGxvY2tzIGhlbGQNCg0KICAgIGlmKHNwYW5uZWQ+PWVod20pDQogICAgICBwcmludGYoIiVz
IEVYQ0xVU0lWRSBST0xMQkFDSyAhISEgJXMtJXMgc3Bhbm5lZCAlZCBsb2dzICglZCBiZWZvcmUg
ZW5naW5lIEhBTFRTKSAtICVkIGxvY2tzXG4iLA0KICAgICAgICAgICAgICB1dGhkLCB0eCwgc3Rh
dCwgc3Bhbm5lZCwgbmxvZ3Mtc3Bhbm5lZCwgbG9ja3MpOw0KDQogICAgZWxzZSBpZihzcGFubmVk
Pj1od20pDQogICAgICBwcmludGYoIiVzIFJPTExCQUNLISAlcy0lcyBzcGFubmVkICVkIGxvZ3Mg
KCVkIGJlZm9yZSBFWENMVVNJVkUgcm9sbGJhY2spIC0gJWQgbG9ja3NcbiIsDQoJICAgICAgdXRo
ZCwgdHgsIHN0YXQsIHNwYW5uZWQsIGVod20tc3Bhbm5lZCwgbG9ja3MpOw0KDQogICAgZWxzZSBp
ZihzcGFubmVkPj13YXJuICYmIHN0YXQ9PSJCIikNCiAgICAgIHByaW50ZigiJXMgTk9URTogJXMt
JXMgc3Bhbm5lZCAlZCBsb2dzICglZCBiZWZvcmUgcm9sbGJhY2spIC0gJWQgbG9ja3NcbiIsDQoJ
ICAgICAgdXRoZCwgdHgsIHN0YXQsIHNwYW5uZWQsIGh3bS1zcGFubmVkLCBsb2Nrcyk7IA0KICB9
DQp9JyB8IA0KDQojIHNlbmQgbWVzc2FnZSB0byBkYmEgYW5kIHNhcA0Kd2hpbGUgcmVhZCBUWCBU
WE1TRw0KZG8NCiAgIyBhZGRpdGlvbmFsIGluZm9ybWF0aW9uDQogIFNJRD1gb25zdGF0IC11fGdy
ZXAgJFRYfGF3ayAne3ByaW50ZigiJXMiLCQzKTt9J2ANCiAgSU5GTz1gb25zdGF0IC1nIHNlc3xn
cmVwICRTSUR8YXdrIC12IHNpZD0kU0lEIC12IHR4bXNnPSIkVFhNU0ciICcNCiAgew0KICAgIGlm
KCQxPT1zaWQpDQogICAgew0KICAgICAgcHJpbnRmKCJMb25nIFRyYW5zOiBQSUQgJWQgb24gJXMu
LiAlc1xuIiwgJDQsICQ1LCB0eG1zZyk7DQogICAgICBicmVhazsNCiAgICB9DQogIH0nYA0KDQog
IGZvciBzZW5kdG8gaW4gJFNFTkRUTw0KICBkbw0KICAgIGVjaG8gJElORk8gfCBtYWlseCAtcyAi
YHVuYW1lIC1uYCBsb25nIHRyYW5zYWN0aW9uIiAkc2VuZHRvIA0KICBkb25lDQpkb25lDQoNCg==

--0__=85256CFC004A62348f9e8a93df938690918c85256CFC004A6234--

Messages In This Thread

• Long transaction problem!!
  luis.lopez02@cfe.gob.mx -- Tuesday, 1 April 2003, at 9:19 p.m.
  • Re: Long transaction problem!!
    Martin Fuerderer -- Wednesday, 2 April 2003, at 2:33 a.m.
  • Re: Long transaction problem!!
    timothy.a.brown@marconi.com -- Wednesday, 2 April 2003, at 8:23 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.