Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle interface to DB2 on OS/390

RE: Oracle interface to DB2 on OS/390

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Mon, 04 Feb 2002 13:30:57 -0800
Message-ID: <F001.00405790.20020204132241@fatcity.com>

Peter,
Do you have an ODBC driver for the DB2 instance that works on AIX?

If you have one or can get one then you may be able to use Oracle's free Heterogeneous services.

See for example:
Metalink note 114820.1 helpful - "QUICK START GUIDE: WIN NT - Generic Connectivity using ODBC"
Also note 109730.1 - How to setup generic connectivity (Heterogeneous Services) for Windows NT
note-107227.1 setup and troubleshoot Generic Connectivity(ODBC) on Unix

Alternatively Oracle may have a licensed Gateway product that will work (at a cost).

Take a look at "Oracle8i Transparent Gateways A Technical Whitepaper August 1999" for a comparison of the 2 - available from Technet or Metalink.

HTH,
Bruce Reardon

-----Original Message-----

Sent: Tuesday, 5 February 2002 8:11

We are working on an application which runs under AIX, using Oracle which needs access to some data stored in a legacy app using DB2 on OS/390. Is it possible to create a DBLink in the Oracle database so that we can query from the DB2 instance?

thanks,
Peter Schauss
Northrop Grumman Corporation
516-346-3148
schaupe_at_mail.northgrum.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Feb 04 2002 - 15:30:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US