Hi,
I'm using replication on linux and aix for a while now. I've set up several
replications from aix to aix, from linux to aix and vice versa. It was
running just fine until a few days ago. I noticed that some target tables
differ from the sourcetables. Some have more records than it's source others
have less records. The majority of the tables is still in sync.
I'm using one way replication for all tables, and all changed data for
partitioned keys is captured as deletes and inserts.
When records are updated, the cd tables show delete statements of the old
records and insert statements for the new records as expected. But the
applytrail table often shows that there were several transaction reworked
meaning that inserts statements fail and are then turned into updates and
updates are turned into inserts when that particular record does not exist
and thus cannot be updated.
I can't figure out why this happens!
I'm expecting the old record to be deleted and the new record to be
inserted. This insert statement seems to fail and is reworked to do an
update. But why??? Can this result in differences between the source and the
target tables??
Hope anyone can help me out here.
Thanks in advance.
J-W Reuling
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com