Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8QJnsq24689 for ; Fri, 26 Sep 2003 14:49:54 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8QJnkc24675 for ; Fri, 26 Sep 2003 14:49:46 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8QHAXi24375 for oracle-l@orafaq.net; Fri, 26 Sep 2003 10:10:33 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D1331; Fri, 26 Sep 2003 10:09:40 -0800 Message-ID: Date: Fri, 26 Sep 2003 10:09:40 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Govindan K" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Govindan K" Subject: Re: Replication from DB2 to Oracle Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_10C8_01C38415.BE2B3C30" ------=_NextPart_000_10C8_01C38415.BE2B3C30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Forgot to add one more aspect. You may consider "extproc"; A Java/C program interface >From DB2 equivalent of "extproc" of oracle. DB2 to pass values to the Java/C program which will in turn connect to Oracle and carry out DMLs. HTH GovindanK <-----Original Message-----> From: Govindan K Sent: 9/25/2003 1:15:22 PM To: ORACLE-L@fatcity.com;ORACLE-L@fatcity.com Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication across Databases of diff.vendors is still not avbl. though it seems you can do DMLs from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G. Don't know about the reverse. Or you may considering any of the following: 1. Dump the DB2 data onto flat file and load using sqlldr / External Tables. 2. Generate SQL insert statements using the equivalent of triggers (capturing the DMLs in the same sequence) and run it in Oracle. In either of the above cases , how are you going to handle DDLs if any that are being done in DB2. The same need to be propogated to Oracle too and the subsequent data inserted correctly. HTH GovindanK <-----Original Message-----> From: Rishi.Jain@VerizonWireless.com Sent: 9/25/2003 12:05:43 PM To: ORACLE-L@fatcity.com Hi, Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in the market ? I would really appreciate if you could suggest something. I am looking to replicate around couple of hundred thousand rows a day. The replication can be every couple of hours. Our main concern is performance on the transactional system ( source system running db2) should not have significant performance impact. Thanks. Thanks Rishi Jain _______________________________________________________________ Get Your 10MB account for FREE at http://mail.arabia.com ! Access MILLIONS of JOBS NOW! _______________________________________________________________ Get Your 10MB account for FREE at http://mail.arabia.com ! Access MILLIONS of JOBS NOW! ------=_NextPart_000_10C8_01C38415.BE2B3C30 Content-Type: text/html Content-Transfer-Encoding: 7bit

Forgot to add one more aspect. You may consider "extproc"; A Java/C program interface

From DB2 equivalent of "extproc" of oracle. DB2 to pass values to the Java/C program

which will in turn connect to Oracle and carry out DMLs.

HTH

GovindanK

<-----Original Message----->

From: Govindan K
Sent: 9/25/2003 1:15:22 PM
To: ORACLE-L@fatcity.com;ORACLE-L@fatcity.com
Subject: Re: Replication from DB2 to Oracle

Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication

across Databases of diff.vendors is still not avbl. though it seems you can do DMLs

from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G.

Don't know about the reverse.

Or you may considering any of the following:

1. Dump the DB2 data onto flat file and load using sqlldr / External Tables.

2. Generate SQL insert statements using the equivalent of triggers (capturing

the DMLs in the same sequence) and run it in Oracle.

In either of the above cases , how are you going to handle DDLs if any that are

being done in DB2. The same need to be propogated to Oracle too and the

subsequent data inserted correctly.

HTH

GovindanK

<-----Original Message----->

From: Rishi.Jain@VerizonWireless.com
Sent: 9/25/2003 12:05:43 PM
To: ORACLE-L@fatcity.com
Subject: Re: Replication from DB2 to Oracle

Hi,

Do any of you have any recommendation about any tools / software which
replicate data between DB2 and Oracle ? Are there any good products out in
the market ? I would really appreciate if you could suggest something.

I am looking to replicate around couple of hundred thousand rows a day. The
replication can be every couple of hours. Our main concern is performance on
the transactional system ( source system running db2) should not have
significant performance impact.

Thanks.

Thanks

Rishi Jain

_______________________________________________________________
Get Your 10MB account for FREE at http://mail.arabia.com !
Access MILLIONS of JOBS NOW!

_______________________________________________________________
Get Your 10MB account for FREE at http://mail.arabia.com !
Access MILLIONS of JOBS NOW! ------=_NextPart_000_10C8_01C38415.BE2B3C30-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: gkatteri@omanmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).