728x90
Error description
xa_recover does not work for MSDTC transactions although they are XA_PREPARED or heuristically completed.
onstat -x looks like that
Transactions
address flags userthread locks beginlg curlog logposit isol retrys coord
...
1e23dc88 -TH-G 0 0 136 151 0x103c COMMIT 0
1e23de90 -TX-G 0 0 145 145 0x229044 COMMIT 0
It should be possible to remove such transactions using an external tool
Problem summary
****************************************************************
USERS AFFECTED:
9.30 and above
****************************************************************
PROBLEM DESCRIPTION:
XA tightly-coupled transaction (via MSDTC), multiple
transaction branches:
-> first branch starts and does some SQL work
-> second branch starts and does some SQL work
-> second branch is prepared and rolled back
-> first branch exits without ending the branch.
an orphaned transaction branch exists.
****************************************************************
RECOMMENDATION:
Request special build or upgrade to higher IDS release such as
10.00 or 11.50 latest fixpack.
****************************************************************http://www-01.ibm.com/support/docview.wss?uid=swg1IC53185
http://www-01.ibm.com/support/docview.wss?uid=swg1IC53133
728x90