How to get truncate event from DB2 database

[sbouzaou]

How to get truncate event from DB2 database, we receive no CDC events when truncate is done on DB2.
Do you know a way to enable this feature with qlik replicate

[Bill_Steinagle]

@sbouzaou 

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.

Note: These are for the Table level policy if happens on the Source will be replicated to the Target.

DDL Handling Policy

When source table is dropped:

DROP target table

When source table is truncated:

TRUNCATE target table

When source table is altered:

ALTER target table

Thanks,

Bill