hi,

how can i use replication for DB2 V8.1 FP 4 to move the data from source to taget table

i tried 'user copy' subset replication, but while i delete some rows from the source table, the same rows are deleted from the Target table too

i need to MOVE the rows from source table to target table, when i delete them from the source it will still found in target table

anyone can help

If all you want is a copy of the data at some point in time, I would suggest that you use some other method like db2move.
Replication is a way to keep the databases in sync. As long as Apply is running, the data changes on the source will show up on the target. If you insist on using replication, stop Apply when your target copy is in the state you want it to stay in.

HTH

Andy

Can I read your query as : Replicate only INSERTs

I can think of a way but never had a chance to test it :

Define source ST1 and CDT of ST1 is CDT_ST1
Create a view V_I_CDT_ST1, a view over CDT_ST1 selecting only ibmsnap_operation I
Define this view as a replication source
Define a replication target and configure apply to use this source ...

In this manner, your INSERTs only will be replicated

Cheers
Sathyaram

one way to do this 'Data Moving'

To replicate the source table SRC1 to taget table TG1 then apply a trigger on the TG1 table (for each row after insert ) to insert the same data into history table HIS1, this history table will contain all the data

We donot care of deleteing records from SRC1 table as this will reflect only in target table TG1 and will never affect the history table HIS1

so what do u think ?

That sounds far better . ... But may fail if you define updates as deletes and inserts ..

Cheers
Sathyaram