Syncing data using cdr sync
Milan Rafaj asked how cdr sync behaves with live transactions and whether a row changed after being read by sync could be overwritten. Paul Watson said he has never lost transactions syncing live systems but avoids large syncs at busy times. Milan noted the behavior is undocumented and big syncs need enough logical logs, CDR_QDATA_SBSPACE and memory. David Williams' question on cdr sync versus cdr repair went unanswered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 ------------------------------ Milan ------------------------------
I have never had a issue with using sync on live systems and getting trans lost. I have always assume the 'live' transactions are delayed but..... never looked Cheers Oauk On 2/22/2024 9:52 AM, Milan Rafaj via IBM TechXchange Community wrote: 0100018dd1846d4b-55cde07c-aebc-4652-8c94-478e6f3927ca-000000@email.amazonses.com"> 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... -posted to the "Informix" group
Should of added, I tend to avoid very large syncs during busy times Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC
Thank you Paul, good experience, relation of sync and live txn is not clearly documented. Sufficient number of logical logs, CDR_QDATA_SBSPACE a SHM would be a must as well for syncing big databases. Milan Raf Senior Lead, Infrastructure/Cloud Architecture Kyndryl Consult +420 737 264 248 www.kyndryl.cz Planned absence/Plánovaná nepřítomnost: 1.3.2024 Kyndryl Česká republika, spol. s r. o. Sídlo: Praha 4, Chodov, V Parku 2308/8, PSČ: 148 00, IČ: 14890992 Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277) Registered address: Prague 4, Chodov, V Parku, 2308/8, Zip code: 148 00 Company ID: 14890992 Entered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277) -- Unless stated otherwise above: Kyndryl Česká republika, spol. s r. o. Sídlo: V Parku 2308/8, Chodov, 148 00 Praha 4, IČ: 096 28 886 Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277) Registered address: V Parku 2308/8, Chodov, 148 00 Prague 4 Company ID: 096 28 886 Registered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277)
HI, Can someone give a quick decription of the differences between cdr sync and cdr repair especially with many active transaction happening at the same time? Regards, David. ------------------------------ David Williams ------------------------------