By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,375 Members | 1,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,375 IT Pros & Developers. It's quick & easy.

Two-phase commit with Federated Database (AIX UDB 8.3)

P: n/a
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
Jan 3 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hmmm. I'm not sure that 2PC with Federated sources is supported in V8. I
know that Federated 2PC to non-IBM dbs is not supported till V9.

Larry

TheAndroid wrote:
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
Jan 4 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.