Partitioning Algorithms (Pros and Cons)

[lacabessa]

Hi,

With Datastage server (not PX), I would like to use the link partitioner to improve the performance of some of my jobs. I know that there are 4 Partitioning algorithms available for Link Partitioner (Round Robin, Random, Hash, Modulus). I will be thankful if someone tell me what are the pros and cons of each algorithm and what are the criterias that should guide our algorithm selection.

Thanks a lot

Mohamed

[shawn_ramsey]

Hi,

With Datastage server (not PX), I would like to use the link partitioner to improve the performance of some of my jobs. I know that there are 4 Partitioning algorithms available for Link Partitioner (Round Robin, Random, Hash, Modulus). I will be thankful if someone tell me what are the pros and cons of each algorithm and what are the criterias that should guide our algorithm selection.

Thanks a lot

Mohamed

We are using Round Robin. I played around with the various options ant they seemed to make no difference in the performance of the job.

[rasi]

Round robin is the default algorithm. For more infomation check the manual servjdev.pdf (Page 13-3)

Thanks
Rasi