1) Adding views - no impact, triggers, indexes - depends on what they
do.(eg, a new unique index, if a row replicated from the source
violates unique keys), columns - again depends(if you add a new
column, with NOT NULL and do not specify a default value)

2 and 3 ) AFAIK, replication does not recreate any object ... FULL
REFRESH copies all records from the source to the target , DIFFERENTIAL
REFRESH replicates only the new inserts/updates and deletes....

4) Search for ' db2 replication ' in google and I remember seeing a few
other vendors who say they provide DB2 replication solution

Cheers

Sathyaram

Originally posted by Dean
> Hello,
>
> I'll have to run data replication for few tables in DB2 7.1
> from source
> server A to target server B once a week. Tables on both sites
> (A&B) already
> exists and have data.
>
> For us it it important that every replication doesn't recreate
> objects in
> database - it should only insert/update the new data.
>
> Because I must make some enhacements on site B I'll have to add
> some new
> columns, indexes, triggers and/or views on target tables.
>
> 1) If I do that, will the replication still be successfull without
> making
> any changes in
> Apply/Capture program (DB2 DataPropagator)?
>
> 2) Does FULL-REFRESH ONLY copying only deletes/inserts rows in target
> table
> without
> recreating it or any other object?
>
> 3) Does DIFFERENTIAL-REFRESH copying only inserts/updates rows in
> target
> table
> without recreating it or any other object?
>
> 4) Is there any other replication programs besides DB2 DataPropagator?
>
> Thank you!
>
>
dEAn

--
DB2 discussion also at http://www.dbforums.com/f8


Posted via http://dbforums.com