Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

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

dima_etkin
Support
Support

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

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

2 Comments
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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived