Informix

Hello, I need to clarify how to use cdr sync

• cdr sync sends always ALL rows and apply them on target using conflict resolution Alway - to speed up we can truncate target table, in order to not update existing rows by sync process
• can we use normal transaction activities during the cdr sync? - how to avoid sync process overwriting change which  happened after row is read by sync process in scenario:
  1.row is read by sync and it is putted directly into send queue together with other rows read by sync process
  2.the same row is changed by application later but this app txn is committed BEFORE sync trans is committed
  In what order are those 2 transactions (application and sync) applied on target?
  
  Thank you

Hello, I need to clarify how to use cdr sync

• cdr sync sends always ALL rows and apply them on target using conflict resolution Alway - to speed up we can truncate target table, in order to not update existing rows by sync process
• can we use normal transaction activities during the cdr sync? - how to avoid sync process overwriting change which  happened after row is read by sync process in scenario:
  1.row is read by sync and it is putted directly into send queue together with other rows read by sync process
  2.the same row is changed by application later but this app txn is committed BEFORE sync trans is committed
  In what order are those 2 transactions (application and sync) applied on target?
  
  Thank you

Hello, I need to clarify how to use cdr sync

• cdr sync sends always ALL rows and apply them on target using conflict resolution Alway - to speed up we can truncate target table, in order to not update existing rows by sync process
• can we use normal transaction activities during the cdr sync? - how to avoid sync process overwriting change which  happened after row is read by sync process in scenario:
  1.row is read by sync and it is putted directly into send queue together with other rows read by sync process
  2.the same row is changed by application later but this app txn is committed BEFORE sync trans is committed
  In what order are those 2 transactions (application and sync) applied on target?
  
  Thank you

Hello, I need to clarify how to use cdr sync

• cdr sync sends always ALL rows and apply them on target using conflict resolution Alway - to speed up we can truncate target table, in order to not update existing rows by sync process
• can we use normal transaction activities during the cdr sync? - how to avoid sync process overwriting change which  happened after row is read by sync process in scenario:
  1.row is read by sync and it is putted directly into send queue together with other rows read by sync process
  2.the same row is changed by application later but this app txn is committed BEFORE sync trans is committed
  In what order are those 2 transactions (application and sync) applied on target?
  
  Thank you