https://community.qlik.com/t5/Qlik-Replicate/How-to-get-truncate-event-from-DB2-database/m-p/2057977#M5616 <P>How to get truncate event from DB2 database, we receive no CDC events when truncate is done on DB2.<BR />Do you know a way to enable this feature with qlik replicate</P> Thu, 06 Apr 2023 12:51:30 GMT sbouzaou 2023-04-06T12:51:30Z https://community.qlik.com/t5/Qlik-Replicate/How-to-get-truncate-event-from-DB2-database/m-p/2057977#M5616 <P>How to get truncate event from DB2 database, we receive no CDC events when truncate is done on DB2.<BR />Do you know a way to enable this feature with qlik replicate</P> Thu, 06 Apr 2023 12:51:30 GMT https://community.qlik.com/t5/Qlik-Replicate/How-to-get-truncate-event-from-DB2-database/m-p/2057977#M5616 sbouzaou 2023-04-06T12:51:30Z https://community.qlik.com/t5/Qlik-Replicate/How-to-get-truncate-event-from-DB2-database/m-p/2058040#M5619 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/225141">@sbouzaou</a>&nbsp;</P> <P>Hi, thank you for the post to the QDI Forums. I would first check the Task Settings and how the Change Processing is set as this is where you can set the settings on the Source as per the below settings. Hope this is help as per the Table and DDL Handling on the Task.</P> <P>Note: These are for the Table level policy if happens on the Source will be replicated to the Target.</P> <DIV class="form-row row"><LABEL class="bold ng-binding">DDL Handling Policy</LABEL></DIV> <DIV class="form-row row"> <DIV class="formWrapLabel"><LABEL class="ng-binding">When source table is dropped:</LABEL></DIV> <DIV class="formWrapContent"> <DIV class="attSelectList attComboBox "> <DIV class="textInputInRowWrap"><SPAN class="non-edit-text ng-binding" title="DROP target table">DROP target table</SPAN></DIV> </DIV> </DIV> </DIV> <DIV class="form-row row"> <DIV class="formWrapLabel"><LABEL class="ng-binding">When source table is truncated:</LABEL></DIV> <DIV class="formWrapContent"> <DIV class="attSelectList attComboBox "> <DIV class="textInputInRowWrap"><SPAN class="non-edit-text ng-binding" title="TRUNCATE target table">TRUNCATE target table</SPAN></DIV> </DIV> </DIV> </DIV> <DIV class="form-row row"> <DIV class="formWrapLabel"><LABEL class="lblOfControl ng-binding">When source table is altered:</LABEL></DIV> <DIV class="formWrapContent"> <DIV class="attSelectList attComboBox "> <DIV class="textInputInRowWrap"><SPAN class="non-edit-text ng-binding" title="ALTER target table">ALTER target table</SPAN></DIV> <DIV class="textInputInRowWrap">&nbsp;</DIV> <DIV class="textInputInRowWrap"><SPAN class="non-edit-text ng-binding" title="ALTER target table">Thanks,</SPAN></DIV> <DIV class="textInputInRowWrap"><SPAN class="non-edit-text ng-binding" title="ALTER target table">Bill</SPAN></DIV> </DIV> </DIV> </DIV> Thu, 06 Apr 2023 14:56:55 GMT https://community.qlik.com/t5/Qlik-Replicate/How-to-get-truncate-event-from-DB2-database/m-p/2058040#M5619 Bill_Steinagle 2023-04-06T14:56:55Z