idea Replicate - Enable sorting data by Clustering key automatically for DB2z and similar sources in Suggest an Idea

Replicate - Enable sorting data by Clustering key automatically for DB2z and similar sources

dima_etkin — Wed, 19 Oct 2022 19:26:14 GMT

Hi,

A lot of times when DB2z source data is loaded from very active tables, customers need to explicitly add an "ORDER BY [cluster index columns]" clause to prevent reading the same record more than once, as a consequence of a record relocation in the physical file while the task is performing a TS scan.

Please add an option for Replicate to automatically add an " ORDER BY [cluster_index_columns]" clause to all source DB2z tables to help preventing duplicates from happening.

This option should work consistently together with the passthrough filters, and any data range partitioning enabled for the table parallel load.

Thanks,

Dima

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

Meghann_MacDonald — Wed, 02 Aug 2023 16:16:57 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 - Enable sorting data by Clustering key automatically for DB2z and similar sources - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:16:59 GMT