Hash Partition Query

hi.prabhunami · Post by **hi.prabhunami** » Tue Sep 17, 2013 3:09 pm

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?

prakashdasika · Post by **prakashdasika** » Tue Sep 17, 2013 6:50 pm

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.