Suggest an Idea

[dima_etkin]

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

[Meghann_MacDonald]

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.