Re: cross platform replication

[michaelr_41@xxxxxxxxxxxxxx]

That's a good method for a data base refresh. Socket programs (or MQ
Series or some type of middleware) with triggers on the iSeries data base
works well too.

On Fri, 14 May 2004 08:38:21 -0500, rick.baird@xxxxxxxxxxxxxxx said:
> 
> Jim,
> 
> We're getting ready to do this exact same thing, but all we're doing is
> creating csv files and dumping them on an NT share for the oracle app to
> pick up.
> 
> If you come up with a better solution, please share.
> 
> Rick
> 
> ---------original message-------------
> We've been talking about buying Oracle's DB/2 AS/400 Gateway product.  In
> considering our application needs we've come to realize that it isn't
> going
> to do what we want because it's going the wrong way.
> 
> We need to replicate data where the AS/400 is the source system.  The
> gateway allows you to create an Oracle view to an AS/400 table.  We're
> dealing with large AS/400 tables, updated frequently.  On the Oracle side
> we'd  have to pull all the data through the view instead of accepting
> periodic updates/changes.
> 
> Is anyone working with replication from an AS/400 to an Oracle database? 
> I
> know IBM has an incredibly expensive solution, and I can think of a few
> complicated ways to roll my own.
> 
> -Jim
> 
> James P. Damato
> Manager - Technical Administration
> Dollar General Corporation
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
-- 
  
  michaelr_41@xxxxxxxxxxxxxx

-- 
http://www.fastmail.fm - Send your email first class