| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ two phase commit |
« View previous topic :: View next topic » |
| Author |
Message
|
| pshan81 |
 Posted: Wed Mar 08, 2006 4:04 am Post subject: MQ two phase commit |
 |
|
Acolyte
Joined: 24 May 2005
Posts: 72
|
| Will MQ two phase commit work when the database and MQ are running on different machines?I am able to perform the same when both are in the same machine.Is there any additional property that needs to be set for that to work? |
|
| Back to top |
|
 |
| mvic |
| Posted: Wed Mar 08, 2006 4:18 am Post subject: Re: MQ two phase commit |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| pshan81 wrote: |
| Will MQ two phase commit work when the database and MQ are running on different machines?I am able to perform the same when both are in the same machine.Is there any additional property that needs to be set for that to work? |
How is your system composed? MQ and a database? WAS, MQ and a database? TXSeries CICS, MQ and a database? Please clarify. |
|
| Back to top |
|
|
| pshan81 |
| Posted: Wed Mar 08, 2006 4:41 am Post subject: |
|
|
Acolyte
Joined: 24 May 2005
Posts: 72
|
|
| Back to top |
|
|
| mvic |
| Posted: Wed Mar 08, 2006 5:08 am Post subject: |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| pshan81 wrote: |
| MQ and database |
The program will have to use the MQBEGIN call. This means the program will have to be local to the queue manager. However, as far as I know, most (all?) database products on MQ's supported environments list will allow XA from their remote client libraries. So, by using this facility in the database software you will be able to have MQ and database software on different machines, and have an app that coordinates 2PC transactions across both.
Disclaimer: check this with the database product manuals and/or their sales/support teams. |
|
| Back to top |
|
|
| pshan81 |
| Posted: Thu Mar 09, 2006 3:57 am Post subject: MQ two phase commit |
|
|
Acolyte
Joined: 24 May 2005
Posts: 72
|
I am getting the following error in the log file specified in the mq.ini path while starting the queue manager.
<<ORACLE XA: Version 8.1.5.0.0. RM name = 'Oracle_XA'.
214115.409.1.1:
Error while trying to retrieve text for error ORA-12545
214115.409.1.1:
xaolgn_help: XAER_RMERR; OCIServerAttach failed. ORA-12545. >
QM.ini entry
--------------
XAResourceManager:
Name=abcd
SwitchFile=/opt/mqm/java/lib/jdbc/jdbcora XAOpenString=Oracle_XA+ACC=P/user/pwd+SesTm=35+LogDir=/tmp/log+threads=TRUE+DB=db
ThreadOfControl=THREAD
My MQ and DB are running in different machine(unix).I have created the switch file using the make file in /opt/mqm/java/lib/jdbc.DBA_PENDING_TRANSACTIONS permission is also set in the DB. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
