topic Re: How to Restart a Qlik Replicate Task from LSN for a DB2 LUW as Source in Qlik Replicate

How to Restart a Qlik Replicate Task from LSN for a DB2 LUW as Source

bishnu — Wed, 18 Jun 2025 13:56:06 GMT

Hi Team,

How to enable the CDC in DB2 LUW as source?

How can we View or Track the Log/LSN (Log Sequence Number)/LRI (Log Record Identifier) from db2 LUW?

Qlik Replicate maintains the stream position (including Log Sequence Number, LSN /LRI of DB2) in its repository.

The task can resume from the stored stream position on the next startup then how can we resume the task taking last LSN?

Where to find last LSN in Qlik replicate task logs and DB2(is there any quay to find it?)

Can you please provide the guidance for it.

Thanks,

Bishnu

OritA — Thu, 19 Jun 2025 07:45:17 GMT

Hi Bishnu,

To start a task from a specific LSN you shuold open the advanced run options (by clicking the small tiangle to the right on the 'run' button) and then choose the option 'Tables are already loaded. Start processing changes from:' --> 'Source change position (e.g. SCN or LSN):' and indicate the requested LSN.
FYI - here is a link to the documentation section that explains how to get/search for a requested LSN:
https://help.qlik.com/en-US/replicate/May2025/Content/Global_Common/Content/SharedEMReplicate/Tasks%20at%20Runtime/monitor_detailed_run_options.htm#How

Regards,

Orit

bishnu — Fri, 19 Sep 2025 19:36:21 GMT

Thank you.