-----Original Message-----
From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Link to DB2Tim,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-----
From: Johnston, Tim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Link to DB2That 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-----
From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L
Subject: Link to DB2
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-1987The 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: Hamid Alavi
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).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.
Title: RE: Link to DB2
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...
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
- Link to DB2 Hamid Alavi
- RE: Link to DB2 Johnston, Tim
- RE: Link to DB2 Hamid Alavi
- RE: Link to DB2 Kevin Lange
- RE: Link to DB2 Johnston, Tim
- RE: Link to DB2 Khedr, Waleed
- RE: Link to DB2 Kevin Lange