Re: Data update in DB2 trigger update in Oracle

On Fri, 29 Mar 2002 22:27:22 +0800, "Big Cat" <kenemail_at_netvigator.com> wrote:

MQ Series can work. If you have an EAI tool such as MQ Integrator or the like you have much of what you need. However, I have had much success with Oracle transparent Gateway for DB2. From Oracle you can run DB2 queries as if they were Oracle queries. You can also run a DB2 SPROC and return the data to Oracle.

Depending on the Release of DB2 you run you can also use Relational connect or purchase IBM Data Joiner which from the DB2 side is simply IBM's version of a database gateway.

>Hi there,
>
>We are now using DB2 and Oracle together where the DB2 is the legacy
>database. As most of the reference data are updated in DB2 from different
>subsystem. We are now looking for a tool which can allow any update in DB2
>triggering the update in Oracle. Can the MQSeries help ?
>
>Regards
>Ken
>
>
Received on Fri Mar 29 2002 - 13:55:11 CST