Re: Need Information on Oracle-DB2 connectivity

>
> Need Information on Oracle-DB2 connectivity
>
> Bruno GEORGES <georgeb_at_worldnet.net> wrote:
 

> I am currently writing a report on recommending solutions on
 connectivity
> issues: communications between our Oracle databases and our DB2
 databases.
> I know that oracle provides some gateway or similar products, but I'd
 like
> to have some advice coming from a person who has already implemented
 such
> architecture .
> Is there somebody who can help me in my investigations?? I'll really
 appriciate it!!
> Bruno GEORGES
> georgeb_at_worldnet.net

George,
We have been using Oracle's Transparent Gateway to DB2 for about a year. It allows an application to connect to an Oracle instance and then transparently access DB2 from there (via Oracle database links) as if DB2 were just another Oracle instance. The gateway handles EBCDIC to ASCII conversion and converting Oracle SQL syntax to DB2 SQL syntax. It allows both read and write to DB2 (with 2 phase commit) as well as cross DBMS joins (i.e. distributed query), although this often does not perform too well. We will be soon testing another Oracle TGW product called TGW to DRDA, which will provide similar functionality, but will be hosted on a UNIX server instead of the mainframe and will connect directly to DB2's DDF (Distributed Data Facility) via IBM's DRDA protocol.

Another note, both of these gateways require SQL*Net at both ends for network connectivity, and both provide a "one way" solution--i.e. Oracle to DB2 but NOT DB2 to Oracle.

Hope that helps some.

    _/_/_/_/_/ _/_/_/_/    _/_/_/_/       //  John R. Call
       _/     _/     _/   _/     _/      //  The Boeing Company
      _/     _/_/_/_/    _/             //  Wichita, Kansas
_/   _/     _/    _/     _/     _/     //  (316) 526-9466
_/_/_/ _/  _/      _/ _/ _/_/_/_/ _/  //  b540jc_at_wbv1.bems.boeing.com

Please note that when John says this is a "one-way" solution, he means that only Oracle can initiate the read or write. DB2 can't use the gateway to transfer data: the request must come from the integrating server. That request could, however, be either a read or write. In other words, this is a two way solution, but the request can only be initiated from the Oracle tool.

The gateway doesn't actually handle the EBCDIC to ASCII translation - this is a function of SQL*Net. The gateway mainly handles three things: determination of where a particular capability lies (built in functions, etc.), SQL syntax conversion, and data conversion. We use DB2's CAF to pass the SQL statement to DB2.

• Paul Anderson *
• panderso_at_ottawa.net *
• http://www.ottawa.net/~panderso/ *
• Ottawa, Canada *

  ---