Technote (FAQ)
Question
What is deletewins conflict resolution
Answer
With timestamp conflict resolution rule, deleted rows can reappear back into replicated tables when update operations are converted back into insert operations (UPSERTS). An upsert operation can occur if a row is deleted from a target server before an UPDATE operation is processed on that target server or if an UPDATE operation was processed by the target server before the INSERT operation for that row. Depending on your business logic, upsert operations might violate referential integrity.
With deletewins conflict resolution:
- Delete operations will win over update operations
- Upserts are NOT allowed.
- Update operations to a server where the Primary Key does not exist, will fail and generate an ATS or RIS file.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.