Re: Loading Oracle from the mainframe (quickly)

I recently worked in a large site where we did this by unloading the data from DB2 to flat files and transporting them across a channel attach gateway and then loading it in using SQL*Loader.

This was considerably faster than using SQL*Connect, but required specialised hardware - the channel attach gateway and software which made the Unix machine (a Sun) appear as an NJE node to the mainframe.

Basically, it worked well and we got good throughput (~90kbps over the channel) but it was a fairly manual procedure - you need to write unload programmes on the mainframe and sql*loader scripts on the Oracle side.

Even if you're using Ethernet, I suspect that the unload to flat file/sql*loader combination would be faster for bulk data. I'm talking hundreds of MB to GB here.

Regards,

Cathryn Symons
IS Consultant
James Illback (illback_at_bcstec.ca.boeing.com) wrote:
: We need to load a lot of DB2 data into Oracle fairly quickly. We do not
: have the ability to use tape. The network is an Ethernet. Does anyone
: have any ideas of fast transfer methods? Thanks.
 

: --
: -----------------------------------------------------------------------------
: Jim Illback | Boeing Computer Services
: illback_at_bcstec.ca.boeing.com | P.O. Box 24346, MS 6C-MM
: (206) 234-0788 | Seattle, WA 98124-0346
Received on Mon Aug 29 1994 - 22:58:54 CEST