https://community.qlik.com/t5/Qlik-Replicate/source-change-position-e-g-SCN-or-LSN-Advanced-Run-option-to/m-p/2470283#M11958 <P>Hi Tajima san,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/142280">@iti-attunity-sup</a>&nbsp;,<BR /><BR />Thank you for reaching out to the Qlik Community.<BR /><BR /><SPAN>Rather than starting the task from a specific date and time, you can resume it using SCN if you have the SCN position. Using a SCN provides a more precise position for starting the CDC. <BR /><BR />For example, your step 3:</SPAN></P> <PRE><SPAN>3. Resume the Log Stream tasks using the current SCN confirmed at Step#2.</SPAN></PRE> <P><SPAN><BR /></SPAN>You could also use date and time instead of SCN.<BR /><BR />Regards,<BR />Desmond</P> Fri, 12 Jul 2024 09:50:35 GMT DesmondWOO 2024-07-12T09:50:35Z https://community.qlik.com/t5/Qlik-Replicate/source-change-position-e-g-SCN-or-LSN-Advanced-Run-option-to/m-p/2470269#M11957 <P>I have some questions about using 'source change position (e.g. SCN or LSN)' Advanced Run option&nbsp;to start Log Stream tasks.</P> <P><BR />This is newly supported from v2023.05, according to the documentation below:</P> <P>Qlik Help<BR /><A href="https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Release_Notes/features.htm" target="_blank">https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Release_Notes/features.htm</A></P> <PRE>What's new?<BR /><BR />Log Stream tasks now support the source change position (e.g. SCN or LSN) Advanced Run option<BR />with the Oracle source endpoint.</PRE> <P>&nbsp;</P> <P>I would like to know what kind of situation we will use this option.&nbsp;</P> <P>I'm assuming the following situation, is it appropriate?</P> <P>Prerequisite:<BR />Large number of updates to the tables not subject to CDC in the source database will occur in advance</P> <P>1. Stop Log Stream tasks during the updates.<BR />2. After all the unrelated&nbsp;updates are completed, check the current SCN.<BR />3. Resume the Log Stream tasks using the current SCN confirmed at Step#2.</P> <P><BR />Are there any other cases where this option would be useful?<BR />Or is there anything we should be careful about when using this option?</P> <P>Regareds,</P> <P>Kyoko Tajima</P> Fri, 12 Jul 2024 08:51:02 GMT https://community.qlik.com/t5/Qlik-Replicate/source-change-position-e-g-SCN-or-LSN-Advanced-Run-option-to/m-p/2470269#M11957 iti-attunity-sup 2024-07-12T08:51:02Z https://community.qlik.com/t5/Qlik-Replicate/source-change-position-e-g-SCN-or-LSN-Advanced-Run-option-to/m-p/2470283#M11958 <P>Hi Tajima san,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/142280">@iti-attunity-sup</a>&nbsp;,<BR /><BR />Thank you for reaching out to the Qlik Community.<BR /><BR /><SPAN>Rather than starting the task from a specific date and time, you can resume it using SCN if you have the SCN position. Using a SCN provides a more precise position for starting the CDC. <BR /><BR />For example, your step 3:</SPAN></P> <PRE><SPAN>3. Resume the Log Stream tasks using the current SCN confirmed at Step#2.</SPAN></PRE> <P><SPAN><BR /></SPAN>You could also use date and time instead of SCN.<BR /><BR />Regards,<BR />Desmond</P> Fri, 12 Jul 2024 09:50:35 GMT https://community.qlik.com/t5/Qlik-Replicate/source-change-position-e-g-SCN-or-LSN-Advanced-Run-option-to/m-p/2470283#M11958 DesmondWOO 2024-07-12T09:50:35Z