DSXchange

Hi,

We have a table which is partitioned on column X.
We are doing a partition based unload for this table using 10 DB2 stages for faster extracts and then merging all the data using a funnel stage.

I wanted to check if in the funnel stage we specify hash partitioning would that put an additional overload on the DB stage due to repartitioning and affect the performance?

It will not effect the performance of the DB stage but will effect the performance of job as the partitions are there on all 10 input links to the funnel.