PWX DB2i CDC reads the journal receiver chains.
So before you reset Journal Entry Sequence Numbers, you probably need to ensure that PWX has captured all the current data. Most likely, this would use roughly the same process as a table structure change:
- Stop activity on the source
- Let PWX run until it has captured everything
- Stop PWX
- Perform the change (Journal Entry Sequence Number reset, in this case)
- Restart PWX
- Allow activity on the source.
However, PWX DB2i is not my strongest skill, so I would suggest raising a case with PWX Support.
Thanks Dan. So before these activities are done in DB2 we have to stop the Informatica CDC workflow and do a cold restart (once PWX DB2 is up)?
Do you think below process is correct or need any changes?
1. Stop activity on the source JDE
2. Let Power Exchange for Informatica run to capture everything
3. Stop Infa CDC workflow
4. Recover the session
5. Stop PWX at source (JDE)
6. Perform the change in JDE (journal reset)
7. Restart PWX at source JDE
8. Allow activity at source JDE
9. Cold start workflow
That looks reasonable to me, but as I stated earlier, you really need to raise a case with PWX Support.
Ok. Thank you. One last question is when we do a cold start after recovering the session, won't it take tokens from the recovered session as tokens would have changed after resetting the journal.
Yeah, it will need new restart tokens for the new journal receiver chains.
So you probably need to cold start.
Again, Please raise a case with PWX Support.
PWX DB2i is not my strong suit.
Ok thank you.