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: Link to DB2

RE: Link to DB2

From: Kevin Lange <kgel_at_ppoone.com>
Date: Fri, 26 Oct 2001 01:58:47 -0700
Message-ID: <F001.003B5690.20011026013520@fatcity.com>

 

Tim;
  Thanks for getting him a link to go to. I could not find a good one anywhere. ALl I could think of doing was sending him the readme's off the install disks.

Kevin
-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 10/25/01 6:25 PM

Out of curiosity, is the DB2 database on NT, Unix or a mainframe? My DB2 knowledge is more on the mainframe side and the Unix/NT implementations may be easier to deal with... But, that being said....  

If you need the data in a real time manner then the Transparent Gateway may be your best bet...  

http://technet.oracle.com/products/gateways/content.html <http://technet.oracle.com/products/gateways/content.html>  

Alternatively, you could connect to the DB2 database from your web app using DRDA (Basically the Net8 equivalent for DB2... I think it stands for Distributed Remote Database Access) and extract the information... Process it and then store it in the Oracle database... Last time I dealt with this there were some third party vendors that offered ODBC drivers but IBM did not have one that shipped with the product... I assume that they have probably come a long way in this area over the last couple years...  

Also, if this is a batch task that happens in the background on periodic intervals, then you may be able to implement another solution... An example would be... Unload the data from DB2 using whatever solutions you have available ( i.e. a DB2 utility, QMF, a custom program ) and place it into a flat file... Then use SQL*Loader to load the information into a staging table on the Oracle side... Process the data and insert it into the "real" tables and don't forget to cleanup the staging table...  

:-)  

Hope this helps...  

Tim

-----Original Message-----
Sent: Thursday, October 25, 2001 5:26 PM To: Multiple recipients of list ORACLE-L

Tim,  

We have an oracle database(8.1.6) on NT2k and we need retrieve some records from another database DB2 and after some processing on these records store it in our database, these all will be doing thru an web base application.
I am looking for the best solution to link the oracle to DB2, don't know ODBC or JDBC will work or may be we need some gateway or third part software, I have no idea.  

-----Original Message-----
Sent: Thursday, October 25, 2001 2:06 PM To: Multiple recipients of list ORACLE-L

That probably depends on what you need the link for... Can you further define the requirement of what you are trying to do?

Tim

PS - I have no experience with them but Oracle does offer Transparent Gateways to other dbms platforms... I'm not 100% sure but I think DB2 is one of them... But depending on your needs it may be more or less then you really need...

-----Original Message-----
<mailto:hamid.alavi_at_quovadx.com> ]
Sent: Thursday, October 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L

List,

What's the best solution for linking oracle to DB2 Oracle 8.1.6 on NT2K

Hamid Alavi
Office 818 737-0526
Cell 818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from

disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.

Please contact the sender immediately by return e-mail and delete the original message from your system.
--

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

Author: Hamid Alavi
  INET: hamid.alavi_at_quovadx.com

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).

The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system.

--

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

Author: Kevin Lange
  INET: kgel_at_ppoone.com

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 Fri Oct 26 2001 - 03:58:47 CDT

Original text of this message

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