Connect

 View Only
  • 1.  Connect CDC Change Selector cannot read partial journal receivers (and why that stops everything)

    Employee
    Posted 08-21-2026 20:27
    What I ran into
    I ran into a situation where replication just wouldn’t move forward, and the Change Selector refused to process data. The root cause was not obvious at first.
    It turned out the journal receiver being used was partial or damaged.

    What actually happens
    On IBM i, the Change Selector depends on complete journal receivers to read transactions.
    If a receiver is:
    • Partial
    • Incomplete
    • Or restored from another system
    then CDC cannot trust it.
    Result:
    • Change Selector cannot start from that receiver
    • It cannot continue reading
    • Replication appears “stuck” even though everything else looks fine

    Why this matters
    CDC is strict about data integrity.
    It does not try to “guess” missing changes or work with incomplete logs.
    If a receiver is partial:
    • CDC will refuse to process it entirely
    • This is by design to avoid corrupt or inconsistent replication
    So even if most of the data is there, CDC will not proceed.

    What actually fixes it
    The resolution is not a quick patch. It requires resetting state correctly:
    • Resync the affected tables
    • Then cold start the Change Selector
    Using options like:
    • *NEXT or *FIRST
    This allows CDC to restart from a clean, valid point instead of relying on a broken receiver.

    What changed for me
    I used to think journal issues would show up as clear errors.
    This made me realize:
    • Sometimes CDC just stops progressing
    • And the issue is deep in how logs were handled or restored
    Also, moving or restoring journal receivers between systems is risky if not done correctly.

    Takeaway
    If the Change Selector is not progressing and nothing else looks wrong:
    • Check the journal receiver state
    • Make sure it is complete and valid
    CDC will always choose data correctness over partial progress.

    Have you ever had a Change Selector stop silently and later found it was due to journal receiver issues?


    ------------------------------
    Adhitya Maya
    *Precisely Software Inc.
    ------------------------------


  • 2.  RE: Connect CDC Change Selector cannot read partial journal receivers (and why that stops everything)

    Employee
    Posted 09-08-2026 05:04
    Thanks for sharing, Adhitya. This is a great reminder that replication issues are not always caused by configuration or connectivity problems. Journal receiver integrity is often overlooked, but CDC's dependence on complete receivers is critical for maintaining data consistency. Understanding this behaviour can significantly shorten troubleshooting efforts when a Change Selector appears stalled.


    ------------------------------
    Neha Goel
    *Precisely Software Inc.
    ------------------------------



  • 3.  RE: Connect CDC Change Selector cannot read partial journal receivers (and why that stops everything)

    Employee
    Posted 11 days ago

    Nice explanation! It's a good reminder that CDC prioritizes data integrity over continuing with incomplete journal information. Checking the journal receiver state can be an important troubleshooting step when the Change Selector is not progressing as expected.



    ------------------------------
    Sathya LJK
    *Precisely Software Inc.
    ------------------------------