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

[bishnu]

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 · Accepted solution]

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

Regards,

Orit

[bishnu]

Thank you.