Informix

 View Only
  • 1.  Syncing data using cdr sync

    Posted Thu February 22, 2024 10:52 AM

    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
    ------------------------------


  • 2.  RE: Syncing data using cdr sync

    IBM Champion
    Posted Thu February 22, 2024 11:15 AM

    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





  • 3.  RE: Syncing data using cdr sync

    IBM Champion
    Posted Thu February 22, 2024 11:19 AM
    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





  • 4.  RE: Syncing data using cdr sync

    Posted Fri February 23, 2024 03:18 AM

     

    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.

    Obsah obrázku text, klipart  Popis byl vytvořen automaticky

    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)





  • 5.  RE: Syncing data using cdr sync

    IBM Champion
    Posted 18 days ago

    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
    ------------------------------