Re: Connect Oracle & Db2

From: Steve Watts, X3-4805 <swatts_at_swatts@vnet.ibm.com>
Date: 1997/05/19
Message-ID: <SWATTS.97May19090650@orca.stl.sanjose.ibm.com>#1/1

IBM has a product called DataJoiner that you can use in combination with DPROPR to propogate from/to DB2/MVS & oracle. As an aside, you can use DataJoiner to join DB2 & Oracle data (and in V2 it supports updating both in the same UOW).

Steve Watts
IBM
DataJoiner Development

In article <337d8445.169072_at_news.ibm.net.il> urimr_at_ibm.net (Uri Margalit) writes:

   Path: ausnews.austin.ibm.com!uunet!in3.uu.net!199.0.154.56!ais.net!news.stealth.net!news.ibm.net.il!news.ibm.net!not-for-mail    From: urimr_at_ibm.net (Uri Margalit)
   Newsgroups: comp.databases.oracle.server,comp.databases.ibm-db2    Date: Sat, 17 May 1997 10:12:01 GMT
   Organization: Unspecified Organisation    Lines: 17
   NNTP-Posting-Host: slip139-92-88-187.tel.il.ibm.net    X-Newsreader: Forte Free Agent 1.1/32.230    Xref: ausnews.austin.ibm.com comp.databases.oracle.server:7668 comp.databases.ibm-db2:8159

Hello!

We need to propogate data from DB2 MVS/ESA to Oracle (UNIX/NT). The tables are big and I don't want to propogate al the tables evreytime, I want only propogate the changes. I use DPROP to propogate the tables from DB2 to DB2, but which tool can I use to propogate from DB2 to Oracle. I also need to propogate from Oracle to DB2, which tool can do that ?

Help will be appriciate.

Uri Margalit.

Please email
me to urimr_at_ibm.net

--
Steve Watts   (swatts_at_vnet.ibm.com)
IBM Corporation
San Jose, CA 95161-9023

Received on Mon May 19 1997 - 00:00:00 CDT