Hi, Would like to hear more views from the list on this issue. Hence the re-post. Thanks to michael for his views. Basically, we are looking for simple Java programs (EJB on websphere might be later) & we are planning to use the latest version of DB2.
Thanks & Regards, Karthik "O'Keeffe, Michael" <[EMAIL PROTECTED]>@AKH-Wien.AC.AT> on 07/14/2003 09:25:45 PM Please respond to MQSeries List <[EMAIL PROTECTED]> Sent by: MQSeries List <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: MQ Design Query a. Yes. You don't mention how you're running this so I'll guess an EJB running in WebSphere on NT? b. Yes, although it probably depends on exactly which version of DB2 you are using. -----Original Message----- From: P Karthikeyan [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 4:52 AM To: [EMAIL PROTECTED] Subject: MQ Design Query Hi all, We have the following design requirement to be satisfied between NT & OS/390. Application running on Windows NT performing a MQGET from a queue in windows/NT & needs to update a DB2 database in OS/390. The whole operations needs to be performed in a single unit of work (i.e support two phase commit). We are planning to use MQCOMMIT/MQBACK from application in NT to commit or undo changes. We are planning use leverage MQ & DB2 XA co-ordination in a single unit of work from application running in NT side. It is mentioned in the MQ System Administration Guide that "The queue manager communicates with the database managers using the XA interface . The following restrictions apply to the database coordination support: 1. The ability to coordinate database updates within MQSeries units of work is not supported in an MQI client application. 2. The MQI updates and database updates must be made on the same queue manager server machine. 3. The database server may reside on a different machine from the queue manager server. In this case, the database needs to be accessed via an XA-compliant client feature provided by the database manager itself" Questions : >From the points 2 & 3 , i assume that the MQ & DB2 can reside in different machines & can support connectivity provided the DB product provides XA compliant client feature. In my case, i have the MQ on NT which will communicate with the DB2 on OS/390 through JDBC support which (looks like) is XA compliant. My Questions are: a. Is it possible to achieve the scenario described above? b. Whether JDBC to connect to OS/390 DB2 is XA compliant. Some samples on MQ & DB2 access using JDBC is available in http://www.developer.ibm.com/tech/sample_code_handler.pl?action=display&obje ct=/tech/sample_code/mq/mqdb2log.java. Can any one in the list help me out on these queries? Thanks in advance for all your help. Regards, Karthik Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
This message was scanned by Interscan Viruswall,[EMAIL PROTECTED],TCS CHENNAI.