MQSeries.net :: View topic - MQ 5.3 2PC with DB2 8.1 by JTA/Base Java

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » IBM MQ Java / JMS » MQ 5.3 2PC with DB2 8.1 by JTA/Base Java

MQ 5.3 2PC with DB2 8.1 by JTA/Base Java

« View previous topic :: View next topic »

Author

Message

mas

Posted: Wed Jul 28, 2004 2:32 am Post subject: MQ 5.3 2PC with DB2 8.1 by JTA/Base Java

Newbie

Joined: 28 Jul 2004
Posts: 2
Location: Tokyo, Japan

Dear Sir,

We need to find the way out, configuring MQ to participate in a Two-Phase-Commit with a java application (using JTA/JDBC transaction function, offered by MQ base java) Our environment is going to be following below.

OS: Windows2000 (SP4)
DC: IBM WebSphere MQ v5.3 (?)
DB: IBM DB2 v8.1 (Fixpack6; JDBC 2.0)
SDK: Java J2SE 1.4.1_06

As a matter of fact, we aren't still able to assure that the version of DB2 is really applicable on this transaction work. IBM formal web site mentions nothing?

The current Fixpack for MQ is 7 & 'interim', and will it be supported ?
http://www-306.ibm.com/software/integration/mqfamily/platforms/supported/wsmq_for_winnt2000_5_3.html

We would be most grateful if you give any information (with a reliable reference) on this issue.

Best regards,
:)

bower5932

Posted: Wed Jul 28, 2004 6:32 am Post subject:

Jedi Knight

Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA

mqdb2log.java at http://www.developer.ibm.com/tech/sampmq.html might be a sample that can help you to get things working.

Fix Pack 7 for WMQ is shipped and supported. I'm not sure where the interim reference came from.

The URL that you reference doesn't have the version of DB2 listed that you want. However, since what you want is later, I'd suggest that you try it out.

JLRowe

Posted: Wed Jul 28, 2004 7:34 am Post subject:

Yatiri

Joined: 25 May 2002
Posts: 664
Location: South East London

I have the same running XA with MQ CSD07,DB2 FP 6. your JMS provider must have 'XA' selected, and you must create a datasource using an XA JDBC provider.

There is a good article on IBM's developer works about how to configure oracle, db2 and MQ in XA.

http://www-106.ibm.com/developerworks/websphere/library/techarticles/0407_woolf/0407_woolf.html

mas

Posted: Wed Jul 28, 2004 6:09 pm Post subject:

Newbie

Joined: 28 Jul 2004
Posts: 2
Location: Tokyo, Japan

Thanks for your reply. Your suggestion may be right,
'trying out' will be the best answer.

The 'interim' reference is below.
https://www6.software.ibm.com/dl/wsmqcsd/wsmqcsd-p

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » IBM MQ Java / JMS » MQ 5.3 2PC with DB2 8.1 by JTA/Base Java

Jump to:

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

Protected by Anti-Spam ACP