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 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
