-
Title
Do Shareplex replicate failed DML on source to target? -
Description
Do Shareplex replicate failed DML on source to target?
-
Cause
General information.
-
Resolution
Shareplex will not replicate the failed DML that occurred on source to the target for replicating tables. At times, in the Post queue the failed DML may appear as shown in a sample output below (using qview utility) but they are only informational in nature and will not be posted to the table in question:
Sque 2, qseq 0, 04/20/11 16:23:52, 119721/4984576, transid 2, ROLLBACK COMMIT, BPQ0E1AAAAAAAABVLz , SCN 7341364556, forward = 0
In nutshell, the failed DML may not be captured at all or may result in a ROLLBACK COMMIT message gathered by Capture process and sent to the target but it does not have any table information in it and will never be posted to the target table but will simply be discarded by Post during the posting stage.