Re: A tough one: Replication Oracle/NT ---> DB2/AS400

I had a similar situation, but Oracle was on AIX rather than NT. We used the Oracle Transparent Gateway for DB2 to communicate between AIX and DB2. I believe that the same product exists for Windows NT.

We had insert, update, delete triggers on all of the Oracle tables. Any modifications to a table would generate an entry in a log table containing the SQL statement needed to do the appropriate insert, delete or update. We then had a PL/SQL procedure that would read this log table and execute each statement against DB2 via the Transparent Gateway. If the mainframe was down, an error would be returned to the PL/SQL routine, which would then 'go to sleep' for a while before trying again. Using the gateway is the same as using a database link, except that your link points to DB2, rather than another Oracle Database.

hope this helps,

Mike

Alan Hopkins wrote:

> The scenario is a new intranet data collection application (ORACLE on NT)
> that will obsolete a respective application over a couple of years (DB2 on
> AS400)
>
> I need to allow data to be persisted in an ORACLE database and replicate
> the data into DB2 on a 400. This replication (thank goodness) is one-way,
>
> What would you do?
> I need to be able to queue the updates as the AS400 periodically goes
> offline, yet the new application hat 'feeds' it is up 24x7. The replication
> should occur at least 'near real time' (every 1/2 hour at least) and real
> time if possible.
>
> I know well how to create a snapshot.... but how best to write to the Db2
> database on the AS400 from NT?
>
> Thanks for any help you can give me on this one.
Received on Mon Nov 15 1999 - 19:50:04 CET