idea Re: Replicate stored changes: drop table ends up in deleting data in the S3 Bucket - Status changed to: Closed - Archived in Suggest an Idea

Replicate stored changes: drop table ends up in deleting data in the S3 Bucket

RSch — Wed, 25 Nov 2020 14:33:18 GMT

We are replicating Data from our operational System on Db2 Z/Os to a Datalake on S3 for analytic purposes.
We are replicating the data in a S3 Bucket to store all the data and especially the changes in a datalake.The replicate task is defined with stored changes and DDL option apply to change table.
The apply to chnages is used becasue we want to have the DDL changes automatic available in the Datalake.

For several reason a change on a table on the source ends up, that the table has to be dropped, and recreated new and the data has to reloaded in this new created table. When this table is replicated the drop table ends up in deleting also all the data in the target. But because we are replicating the data into a datalake, we don't want to delete this history of the data. The idea of datalake is never delete any data.
Is it possible to change the behavior of the task, that when a table is dropped in the source, this action does not end up with deleting the data in the target?

There is similar behaviour available with apply changes. There it is possible to have the option ignore drop table.

Can such option also be included in stored changes?

Re: Replicate stored changes: drop table ends up in deleting data in the S3 Bucket - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Wed, 23 Dec 2020 14:00:08 GMT

Thank you for the feedback. We would like to collect feedback and will consider for a future release.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 16:19:16 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Replicate stored changes: drop table ends up in deleting data in the S3 Bucket - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:19:17 GMT