All,
I'm having a difficult time trying to implement two-phase commits
across federated database members in UDB 8.3. I've tried using MQ (v
6.0) as the transaction manager and UDB tells me that having a 64bit
transaction manager and a 32bit database is not valid. I updated my
testing database to 64 bit but my 32 bit COBOL applications no longer
built correctly.
I have created an "in-process" XA transaction coordinator which
correctly handles updates when I am updating tables local to the
Federated database. However, once I do something across data sources,
I get an -30090 with a reason code 18. The primary complaint for this
reason code is there is a UOW already started using a one phase commit
source.
I don't understand what I don't have configured correctly. Is this
even possible?
Thanks in advance.
Andy