topic Re: Weekly reset of journal sequence number (architecture : replication db2 to snowflake) in Qlik Replicate

Weekly reset of journal sequence number (architecture : replication db2 to snowflake)

IDLTeam — Tue, 19 Sep 2023 00:19:56 GMT

Hello Qlik community,

I have some flows that replicate data from DB2 to Snowflake.

To do this, the process goes through jounals and libraries.

To sum up, I have two type of tasks : A reading task that reads data (changes) from DB2 (endpoint IBM DB2 for iSeries) and a writing task to replicate data in Snowflake. The process is working well.

My question :

The team responsible for the journals wishes to implement a weekly reset of the journal sequence number.

So, has anyone encountered this change before ? Do you think it will impact the replication flows (if it can generate errors side effects etc...) ?

Our goal is to assess potential impacts before implementing this weekly reset.

Thank you

Re: Weekly reset of journal sequence number (architecture : replication db2 to snowflake)

john_wang — Tue, 19 Sep 2023 06:07:54 GMT

Hello @IDLTeam ,

Thanks for reaching out to Qlik Community!

Qlik Replicate calls the API TABLE(QSYS2.Display_Journal()) to get changes from DB400 Journal. From theory the journal sequence number reset (whatever when the system IPL, or vary on an independent disk pool) does not impact Replicate getting changes. However I'd like to suggest you conduct an acceptance test on lower environment to double-confirm.

BTW, please take note the Journal receivers must be System Managed.

Hope this helps.

Regards,

John.

Re: Weekly reset of journal sequence number (architecture : replication db2 to snowflake)

Barb_Fill21 — Fri, 22 Sep 2023 04:09:49 GMT

Hi @IDLTeam

I agree with @john_wang I would suggest you try this in a Test environment first to prove what the behavior will be.

It may be needed to stop the tasks before you do the re-sequencing of the receiver files. And then resume the task.

Please post here with your results.

Many Thanks

Barb

Re: Weekly reset of journal sequence number (architecture : replication db2 to snowflake)

IDLTeam — Wed, 18 Oct 2023 19:33:53 GMT

Thank you @john_wang and @Barb_Fill21 for your answers.

No impact for the reset of jounal sequences.