Re: DB2/Oracle Gateway

Actually, if you are doing joins between the databases, DataJoiner is the the hands down winner. The OTG or the Oracle optimizer fails to reconize and optimize joins from 2 different locations. Thus it has a tendancy to to full table scans in DB2 (and bring ALL rows from DB2 back to Oracle - YUK!). DataJoiner optimizes the joins and brings back only the rows needed, it appears to open cursors and do fetches to the remote database(s).

If you have more questions drop me a line, I did an evaluation of DataJoiner last fall (and we purchased it) and we already own the OTG (for replication). I have some documentation that proves this point.

Steve Dancisin / sdancisin_removethis_at_highmark.com (get rid of the _removethis before replying)
Oracle Database Services
Highmark Blue Cross Blue Sheild

Jochen Luebbers wrote in message <379EA754.41C6_at_tde-online.de>...
>Ed Lefkowitz wrote:
>>
>> Hi,
>>
>> I'm looking for a solution to allow a DB2 (under AIX) application to
>> access Oracle (v8.x under Solaris) tables along with it's own DB2
>> tables. I know that Oracle has a transparent gateway that allows DB2
>> tables to appear like Oracle tables in an application. Is there a
>> counterpart in the DB2 arena to make Oracle tables appear like DB2
>> tables within an application?
>>
>> Any viable suggestions welcome.
>>
>> Thanks,
>>
>> Ed Lefkowitz
>> MCIWorldcom
>> Arlington, VA
>>
>The "Data Joiner" will do the job.
>
>--
>Jochen Lübbers luebbers_at_tele-data-electronic.de
>Software Development Group I luebbers_at_tde-online.de
>TDE - Tele Data Electronic GmbH sw1_at_tde-online.de
Received on Wed Jul 28 1999 - 10:44:15 CDT