You don't say what your target database is. Assuming it is DB2 on Intel/UNIX/Linux, you do not need Datajoiner (Datajoiner ... and now DB2
Information Integrator ... are only for heterogeneous data source access). However (again assuming that DB2 on Intel/UNIX/Linux is your
target), you do need a database and Data Propagator Apply on your target system (actually ... you can use an Apply program on the source
system to "push" the updates out as an alternative, but a pull is preferred). This is not supplied by DB2 Connect.
Larry Edelstein
> Hi All;
> As usual any help GREATLY appreciated, but may require iSeries
[quoted text clipped - 12 lines]
>
> Help?!
Pete H - 30 Sep 2003 14:41 GMT
Hi Larry;
Thanks very much for the response - VERY helpful. My target DBs are on
the Windows server that Connect is on. Based on the preferred "pull"
configuration, do need DataPropagator on the iSeries box? Can I "pull"
from iSeries sources using Connect using Capture and Apply definitions
using Replication Center on the Windows box? Or is DataPropagator
required on both platforms?
I'm really trying to understand the proper configuration for the
simplest way to accomplish the movement of DB2 data from iSeries to
Wintel. I've spent ALOT of time looking at multiple IBM doc sources,
but so much is changing with V8 and iSeries V5R2 taht I find myself
getting confused. I REALLY appreciate your response and if there's
some single piece of doc I'm missing.
Pete H
> You don't say what your target database is. Assuming it is DB2 on Intel/UNIX/Linux, you do not need Datajoiner (Datajoiner ... and now DB2
> Information Integrator ... are only for heterogeneous data source access). However (again assuming that DB2 on Intel/UNIX/Linux is your
[quoted text clipped - 21 lines]
>
> --
Larry Edelstein - 30 Sep 2003 15:32 GMT
Pete,
DB2 Connect is merely a "transport" or connectivity mechanism and does not perform replication. It is a required prereq for movement of data
from i-series to Intel/UNIX/Linux. You still didn't say what your target data source is on Windows. If they are DB2, you don't need Datajoiner
or Information Integrator. DB2 Connect has nothing else to do with replication other than replication uses it to communicate.
There are two types of replication supported by DpropR: Complete Refresh (completely replace the contents of the target table with the contents
of the source table) and incremental updates/update propagation (capture updates to a given table as they occur and propagate them to the
target). If you want to do update propagation, DataPropagator Capture is required on the iseries box. Based on the pull configuration,
DataPropagator Apply is required on the target box. In either scenario, you can use the Replication Center on the Windows box to create
definitions.
Hope this helps.
Larry Edelstein
> Hi Larry;
> Thanks very much for the response - VERY helpful. My target DBs are on
[quoted text clipped - 38 lines]
> >
> > --
Pete H - 30 Sep 2003 18:26 GMT
Hi Larry;
I finally found the answer to all of my questions. The magic redbook
is "A Practical Guide to DB2 UDB Replication V8". It fills in all of
the gaps between recent announcements, the Replication Guide and
various white papers that had my head spinning. Thanks again for your
help, but I THINK I have the resource I need now.
Pete H
> You don't say what your target database is. Assuming it is DB2 on Intel/UNIX/Linux, you do not need Datajoiner (Datajoiner ... and now DB2
> Information Integrator ... are only for heterogeneous data source access). However (again assuming that DB2 on Intel/UNIX/Linux is your
[quoted text clipped - 21 lines]
>
> --