RE: Replication

We used both db2 connect(from IBM) and the flat file download method on two separate systems. Believe me less stress with the FLAT FILE download method.

Download from DB2 to flat file is less elegant , yet the load scripts (with a little jigging) between DB2 and Oracle are compatible, its totally safe and reliable, and once set up you can forget about it.

Using DB2 Connect , problems with network,big db2 tables we had to download to LOCAL pc ,Then use MICROSLOP ACCESS, rows go missing, etc... this was our experience but the set up was done by the programmers, so I don't want to trash the product completely,could well have been a bit of incompetence from our guys also.

Sam

-----Original Message-----
From: Stephane Faroult [mailto:sfaroult_at_oriole.com] Sent: Wednesday, January 17, 2001 1:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: Replication

Any reason for not using flat files and SQL*Loader ? Still seems to me the safest (and possibly fastest) for moving big volumes between heterogeneous environments.

Regards,

Stephane Faroult
Oriole Corporation

Sherrie.Kubis_at_swfwmd.state.fl.us wrote:

> Environment:
>
> Oracle 8.1.5.0.0. Compaq Tru64 UNIX
> Oracle Transparent Gateway to DB2
> DB2 database on an IBM mainframe
>
> I presently copy data nightly from our IBM DB2 database into Oracle using
> 'complete' refresh snapshots. 'Fast' refreshes cannot be done because of
> the different database architectures. While this suffices for small
> dataset replication, we will soon have a requirement to transfer quite a
> bit of data (size undetermined at this time, other than 'lots'). Is
there
> anyone out there doing this kind of thing between disparate databases? A
> software tool that may work? Any insights would be appreciated.
>
> Sherrie Kubis
> Southwest Florida Water Management District
> 2379 Broad Street
> Brooksville, FL 34604
> 352.796.7211 Ext 4033
> Fax: 352-754-6776
> sherrie.kubis_at_swfwmd.state.fl.us

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).