STT – Configure & Recover Db2 Purescale as a Qlik Replicate Source Endpoint

This session will address:
– Replicate Target vs Source
– How to setup Purscale end point
– How to recover
– Troubleshooting tips

For more information:
https://community.qlik.com/t5/Support-Knowledge-Base/Configure-amp-Recover-Db2-Purescale-as-a-Qlik-Replicate-Source/ta-p/1784224

Please rate this video here:
https://survey.qlik.com/jfe/form/SV_6R1D8FuN4DEEjbM?VideoId=ZNfyPEK5FyE&VideoTitle=STT%20-%20%20Configure%20&%20Recover%20Db2%20Purescale%20as%20a%20Qlik%20Replicate%20Source%20Endpoint

00:00 – Intro
01:00 – What is Replicate and how does it work?
03:38 – What is pure Scale?
05:55 – Setting up a Db2 pureScale endpoint
06:52 – Creating a full load task
10:03 – Demonstrating how CDC works
12:22 – What happens if task fails?
13:21 – Error handling settings
14:03 – How to manually recover a Purescale task
17:46 – Tip for after recovery
18:55 – A look at the Oracle target
20:05 – Q&A

Qlik Replicate User Guide
https://help.qlik.com/en-US/replicate/November2020/pdf/Replicate%20Setup%20and%20User%20Guide.pdf

Db2 Command used to get the list of logs:
db2pd -log -db NAMEOFDATABASE

Db2 Command used to get the LRI position:
db2flsn -db NAMEOFDATABASE -lrirange LOGFILENUMBER

Administrative commands for Db2:
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/com.ibm.db2.luw.admin.cmd.doc-gentopic4.html