| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQSI and IMS database |
« View previous topic :: View next topic » |
| Author |
Message
|
| loveneesh |
 Posted: Fri Mar 19, 2004 5:02 am Post subject: MQSI and IMS database |
 |
|
Novice
Joined: 24 Mar 2002
Posts: 11
|
Hi,
I have broker on Unix box and in one of the message flows will connect to IMS database on M/F, is this possible? If yes, can this be a coordinated transaction, I mean 2-PC here.
The scenarion would be MQSeries (Unix) --> MQSI Broker (Unix) --> IMS Database (MainFrame)
Thanks
Loveneesh |
|
| Back to top |
|
 |
| JT |
| Posted: Sat Mar 20, 2004 7:48 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Have you taken a look at "IMSConnect/IMSConnector for Java" from IBM?
We use IBM's DB2Connect from our v5.0.2 message brokers, running on Solaris/Unix servers to access mainframe DB2 tables via SQL commands imbedded in compute/database nodes. DB2Connect supports ODBC, so WMQIMB can be configured through settings in the .odbc.ini file and the establishment of the DB2 catalog on the server.
Taking a quick look at "IMSConnect/IMSConnector for Java", it appears the product doesn't offer support for ODBC, but does for JDBC, so your solution may reside in developing a custom plug-in using IMSConnector for Java. Of course the IMSConnect component would have to be implemented in your mainframe IMS environment.
http://www-306.ibm.com/software/data/db2imstools/imstools/imsjavcon.html
http://www-306.ibm.com/software/data/ims/v7/con4java.pdf |
|
| Back to top |
|
|
| bolek |
| Posted: Mon Mar 22, 2004 12:48 am Post subject: |
|
|
Apprentice
Joined: 25 Jul 2002
Posts: 35
Location: Germany
|
WMQI 2.1 does not support ODBC/JDBC from custom plug-ins ( see WMQI Prog. Guide ). I can't find this limitation in V5 documentation, but I think this still be valid, because direct access to xDBC may violate WMQI transactions handling.
P.S.
"Database access
The broker uses Open Database Connectivity (ODBC) as an interface to its own internal database, and to customer enterprise databases accessed in Filter, Compute, Database, and related processing nodes. The ODBC environment cannot be accessed using the plug-in node interface. Database access must be performed using the implementation functions supplied for that purpose (see "SQL statement handling" on page 128), or by using the supplied processing nodes.
[...]
Database access must be performed using the methods supplied for that purpose, or by using the supplied processing nodes.
Use of Java Database Connectivity (JDBC) within plug-ins written in Java is not supported." |
|
| 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
|
|
|
|
