article Does the DB2 Native Endpoint capture changes when loading data with DB2 LOAD REPLACE? in Official Support Articles https://community.qlik.com/t5/Official-Support-Articles/Does-the-DB2-Native-Endpoint-capture-changes-when-loading-data/ta-p/1730439 <DIV class="lia-message-template-question-zone"><STRONG>Question:</STRONG></DIV> <DIV class="lia-message-template-question-zone"><SPAN style="font-family: inherit;">Does the DB2 Native Endpoint capture changes when loading data with DB2 LOAD REPLACE?</SPAN></DIV> <DIV class="lia-message-template-question-zone"> <P><SPAN>&nbsp;</SPAN><BR /><SPAN>Reading the IBM documentation, it says that if you specified LOG=yes the changes are actually logged.</SPAN></P> </DIV> <DIV class="lia-message-template-answer-zone"><STRONG>Answer:</STRONG> <P><SPAN>The DB2 LOAD REPLACE is done on the logical/row level, thus even when specifying LOG=yes, we cannot get the relevant CDC information from the logs.</SPAN><BR /><SPAN>&nbsp;</SPAN><BR /><SPAN>An alternative method is issuing a TRUNCATE and then LOAD RESUME SHRLEVEL CHANGE.</SPAN></P> </DIV> Fri, 28 Aug 2020 10:11:53 GMT David_Fergen 2020-08-28T10:11:53Z Does the DB2 Native Endpoint capture changes when loading data with DB2 LOAD REPLACE? https://community.qlik.com/t5/Official-Support-Articles/Does-the-DB2-Native-Endpoint-capture-changes-when-loading-data/ta-p/1730439 <DIV class="lia-message-template-question-zone"><STRONG>Question:</STRONG></DIV> <DIV class="lia-message-template-question-zone"><SPAN style="font-family: inherit;">Does the DB2 Native Endpoint capture changes when loading data with DB2 LOAD REPLACE?</SPAN></DIV> <DIV class="lia-message-template-question-zone"> <P><SPAN>&nbsp;</SPAN><BR /><SPAN>Reading the IBM documentation, it says that if you specified LOG=yes the changes are actually logged.</SPAN></P> </DIV> <DIV class="lia-message-template-answer-zone"><STRONG>Answer:</STRONG> <P><SPAN>The DB2 LOAD REPLACE is done on the logical/row level, thus even when specifying LOG=yes, we cannot get the relevant CDC information from the logs.</SPAN><BR /><SPAN>&nbsp;</SPAN><BR /><SPAN>An alternative method is issuing a TRUNCATE and then LOAD RESUME SHRLEVEL CHANGE.</SPAN></P> </DIV> Fri, 28 Aug 2020 10:11:53 GMT https://community.qlik.com/t5/Official-Support-Articles/Does-the-DB2-Native-Endpoint-capture-changes-when-loading-data/ta-p/1730439 David_Fergen 2020-08-28T10:11:53Z