Note: This tab is enabled only when the Source DB Mode is set to CDC.

CDC Purge

The CDC Purge menu item can be used to delete the data of change records other than the old data based on user input about the number of days of data that should be deleted and the maximum number of records that should be deleted per batch. To delete change data records, from CDC → CDC Purge, select the source database and the number of days of data that you want to retain. Specify the number of records to be processed per batch and click Submit.
Note: If the CDC_PURGE_DAYS property is not specified, this menu item will be disabled.

CDC Count

The CDC Count menu item can be used to get the actual record count of the CDC change tracking table based on whether the records are processed or not processed. This can be done by selecting the database from Select Database and then selecting Operation Type as Applied/Not Applied from CDC → CDC Count.

Users can get the processed records by selecting Applied from the Operation Type drop down. To get the list of records that are not processed, used should select Not Applied from the Operation Type drop down.