| Author |
Message
|
| zpat |
 Posted: Wed Nov 19, 2003 3:16 am Post subject: Can MQSI/WMQI/WBIMB access DB/2 on S/390 from the broker? |
 |
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Can DB/2 on OS/390 be used as an application database using the ODBC interface from a message broker running on AIX?
Is the answer different for MQSI 2.0.2, WMQI 2.1 and WBIMB 5.0?
I notice mention of DB/2 OS/390 support for WMQI 2.1 but I am not clear if that refers to use by message brokers themselves running on OS/390 or not.
If it can be used - presumably there is no XA support? |
|
| Back to top |
|
 |
| psn |
| Posted: Wed Nov 19, 2003 4:06 am Post subject: |
|
|
Disciple
Joined: 30 Oct 2002
Posts: 193
Location: France
|
You can acces to DB2 ZOS over ODBC / DB2 Connect. I had 2 Project with such konfiguration. I had call an UDF on DB2 ZOS and access Tables.
PSN |
|
| Back to top |
|
|
| zpat |
| Posted: Wed Nov 19, 2003 5:53 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| What version of MQSI/WMQI and DB/2 were being used? Thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 19, 2003 6:15 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I've connected to a Z/OS DB2 (I think version 6!) from WMQI v2.1 running on Windows. I had to create a WMQI database user that matched a Z/OS user, though.
But I wasn't using globally coordinated transactions - just broker coordinated.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| zpat |
| Posted: Thu Nov 20, 2003 1:14 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| That sounds like what I was expecting so reasonably hopeful. Thanks. |
|
| Back to top |
|
|
| kirani |
| Posted: Sat Nov 22, 2003 11:16 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
We use DB2 connect (I think ) to read data from M/F DB2 tables. Our DBA has also created user mapping in our local DB2 UDB database so that we don't have to create the same user-id, which broker uses to access DB on the M/F.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
