IBM Support

What is deletewins conflict resolution

Technote (FAQ)


What is deletewins conflict resolution


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.

Document information

More support for: Informix Servers

Software version: 11.5

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1441276

Modified date: 2012-09-10