473,322 Members | 1,403 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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

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
1 2680
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Lennart Jonsson | last post by:
I need to do a two phase commit (a transaction over a table and a nickname). Trying to do so gives me the error SQL30090N reason = 18 The suggested action is: If multiple data sources need to...
1
by: _link98 | last post by:
On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure use two-phase-commit with nicknames and if DB2 provides the Transaction-manager? i.e. in the same transaction, can an SQL/PL...
29
by: Stefan Slapeta | last post by:
There have been many announciations that VC 8.0 will finally support two phase template lookup; now, after I installing VC 2005 Express I had to realize that it still doesn't! What has happend...
1
by: hharry | last post by:
hello all, i have a web service method which queries a database and returns the query result in an xml string. is it possible to implement a two-phase web service which returns an immediate...
5
by: Ravi Chirawala | last post by:
Is Two phase commit allowed in DB2? We need to update a local tables and few federated tables in a single Unit of Work. Is it possible to do ? Regards, Ravi
2
by: amoon.ljlj | last post by:
Hello , My question is: does ms sql support two phase commit protocol? and Why if no. How if yes. Thank you
13
by: paul.joseph.davis | last post by:
Hi, I've just had my first encounter with two-phase lookup and I'm scratching my head a bit. The idea behind two phase look up is pretty easy to understand, but I have a case that fails to...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.