| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Can MQSI v2.1 database node connect to AS400? |
« View previous topic :: View next topic » |
| Author |
Message
|
| ajomillar |
 Posted: Thu Dec 09, 2004 9:34 am Post subject: Can MQSI v2.1 database node connect to AS400? |
 |
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
| Wondering if MQSI v2.1 database node can connect to an AS400? Is this just a ODBC driver issue? The node will update/insert into an AS400 file system (not using DB2/400). |
|
| Back to top |
|
 |
| chenulu |
| Posted: Thu Dec 09, 2004 6:47 pm Post subject: |
|
|
Voyager
Joined: 27 Mar 2002
Posts: 87
Location: Research Triangle Park, NC
|
Hi,
WMQI connects to an application DB via an ODBC connection. The only supported DBs are DB2, Oracle, Sybase and SQL-Server (on Windows) for which there are ODBC drivers supplied by IBM.
Since there is no IBM supplied ODBC driver, you would not be able to connect to AS/400 DBs.
-- Chenulu |
|
| Back to top |
|
|
| chenulu |
| Posted: Fri Dec 10, 2004 3:56 am Post subject: |
|
|
Voyager
Joined: 27 Mar 2002
Posts: 87
Location: Research Triangle Park, NC
|
Hi,
WMQI connects to an application DB via an ODBC connection. The only supported DBs are DB2, Oracle, Sybase and SQL-Server (on Windows) for which there are ODBC drivers supplied by IBM.
Since there is no IBM supplied ODBC driver, you would not be able to connect to AS/400 DBs.
-- Chenulu |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Sat Dec 11, 2004 7:02 am Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
MQSI V2.1 as well as WBIMB can access a DB2 database on an AS/400 via a combination of the DB2 ODBC driver and DB2 Connect. There are some specific considerations in terms of access security - the userid/pwd associated with the MQSI Broker must also be valid on the AS/400 for data access. In this respect, WBIMB is better.
When this support was first provided, now about 4 years ago, it required fixes for DB2 Connect, DB2 on AS/400 and MQSI 2.1. But, as long as things are relatively current, that will not be a concern. What you'll need to do is to define the connection between your broker machine and the AS/400 using the DB2 Connect product. Of course, you'll need the typical ODBC definitions, and so on. Getting the right level of security set up on the AS/400 can also be a challange.
I personally know one of the eraly users of the "fixed" code. He moved up to WBIMB last year.
If you look carefully at te support website, it does state that the iSeries (or AS/400) is supported for application databases. This means that a Broker database cannot go there.
Cheers
Bill
_________________
Bill Matthews |
|
| 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
|
|
|
|
