how to terminate global transactions?

On my Informix instance I have two global transactions holding some locks. See onstat -G and onstat -x output below. How can I get rid of them? Also after a server reboot they are still there. onmode -Z <address> or onmode -H <address> do not work (see below). IBM Informix Dynamic Server Version 11.50.UC7IE on Solaris SPARC 10. Global Transaction Identifiers address flags isol timeout fID gtl bql data 56656bd8 -LX-G LC 0 131075 30 28 312D2D35336530656466663A613139383A34633139336231393A373461652D35336530656466663A613139383A34633139336231393A37346233 56656e28 -LX-G LC 0 131075 30 28 312D2D35336530656466663A613139383A34633139336231393A373463312D35336530656466663A613139383A34633139336231393A37346336 2 active, 128 total Transactions est. address flags userthread locks begin_logpos current logpos isol rb_time retrys coord 56655018 A---- 56623018 0 - - COMMIT - 0 56655268 A---- 56623638 0 - - COMMIT - 0 566554b8 A---- 56623c58 0 - - COMMIT - 0 56655708 A---- 56624278 0 - - COMMIT - 0 56655958 A---- 56624898 0 - - COMMIT - 0 56655ba8 A---- 56624eb8 0 - - COMMIT - 0 56655df8 A---- 566254d8 0 - - COMMIT - 0 56656048 A---- 56625af8 0 - - COMMIT - 0 56656298 A---- 56626118 0 - - COMMIT - 0 566564e8 A---- 56626738 0 - - COMMIT - 0 56656738 A---- 56626d58 0 - - COMMIT - 0 56656988 A---- 56627378 0 - - COMMIT - 0 56656bd8 -LX-G 0 2 logid 303 303:0x64b2622c COMMIT 2:58 0 56656e28 -LX-G 0 2 logid 303 303:0x64b2922c COMMIT 2:58 0 56657078 A---- 56627fb8 0 - - COMMIT - 0 566572c8 A---- 56627998 0 - - COMMIT - 0 56657e58 A---- 56629218 0 - - COMMIT - 0 17 active, 128 total, 28 maximum concurrent > onmode -Z 1449487912onmode: Cannot kill transaction 0x56656e28. Only I-STAR subordinates that are PREPARE'd or HEURISTICally ABORT'd may be heuristically completed. > onmode -H 1449487912 onmode -H may only be used to kill heuristically completed transactions.

On Jun 27, 6:51 pm, Frank Langelage <fr...@lafr.de> wrote: > On my Informix instance I have two global transactions holding some > locks. See onstat -G and onstat -x output below. > How can I get rid of them? > Also after a server reboot they are still there. > onmode -Z <address> or onmode -H <address> do not work (see below). Hi Frank, onmode will not work AFAIK. These global transactions were started by a "distributed" application, (transaction manager) and Informix is only a participant in XA transaction. Transaction manager (a wild guess: Java app server?) needs to send either a commit or rollback now to this participant. Did your application crash? If it implements TP/XA transaction management fully it should have means of finishing transactions in progress after it comes back online. If nothing works, call IBM Tech Support, they have a tool which will clean this up for you. HTH Davorin