URGENT HELP: onmode -Z can't kill the transaction
Posted in 1999
Topics: Server Administration, Logging & Checkpoints
This is a multi-part message in MIME format.
------=_NextPart_000_000A_01BE9191.3AAD6480
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
We use Informix Dynamic Server 7.23 on DEC Alpha and have problems with =
the two-phase commit protocol. The communication between the coordinator =
and the participant was broken. In the participant site the transaction =
rolled back remained open and the logical logs reached the LTXEHWM. The =
server is blocked. I have tried to kill the transaction (onmode -Z) but =
the transaction is still opened.=20
Here is the output of the command onstat -x.
116a5798 --H-S 0 0 22539 COMMIT 31 =
server
Why the onmode -Z can't kill the transaction and how can I proceed =
because we have problem with the network and I'm not sure when the =
connection will be reestablished.
Thanks in advance,
Carolina
------=_NextPart_000_000A_01BE9191.3AAD6480
Content-Type: text/html;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Dkoi8-r http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>We use Informix Dynamic Server 7.23 =
on DEC Alpha=20
and have problems with the two-phase commit protocol. The communication =
between=20
the coordinator and the participant was broken. In the participant site =
the=20
transaction rolled back remained open and the logical logs reached the =
LTXEHWM.=20
The server is blocked. I have tried to kill the transaction (onmode -Z) =
but the=20
transaction is still opened. </FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Here is the output of the command =
onstat=20
-x.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000=20
size=3D2>116a5798 --H-S=20
0 =
=20
0 22539 =
COMMIT =20
31 server</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Why the onmode -Z can't kill the transaction and how =
can I=20
proceed because we have problem with the network and I'm not sure when =
the=20
connection will be reestablished.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Carolina</FONT></DIV></BODY></HTML>
------=_NextPart_000_000A_01BE9191.3AAD6480--