Skip to main content

What is deletewins conflict resolution


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:

(0 users)Average rating

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.

Rate this page:


(0 users)Average rating

Add comments

Document information

Informix Servers


Software version:
11.5


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


Reference #:
1441276


Modified date:
2012-09-10

Translate my page

Content navigation