Auto Partitioning

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kishorenvkb
Participant
Posts: 54
Joined: Mon Dec 24, 2007 9:27 am

Auto Partitioning

Post by kishorenvkb »

Hello,

How can we find that what partition method was used during an execution if the "Auto" Partition is used in the stages?

Thanks
mikegohl
Premium Member
Premium Member
Posts: 97
Joined: Fri Jun 13, 2003 12:50 pm
Location: Chicago
Contact:

Post by mikegohl »

Read the Job Score.
Michael Gohl
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Or know the rules. Auto gives:
  • Round Robin if the link is from sequential to parallel or from parallel to sequential.

    Same if the link is from parallel to parallel with the same degree of parallelism, or Round Robin otherwise.

    Entire if the link is a reference input link to a Lookup stage.

    Hash if the link is an input link to a stage that requires key-partitioned input.

    DB2 if the link is an input link to a DB2/UDB Enterprise stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kishorenvkb
Participant
Posts: 54
Joined: Mon Dec 24, 2007 9:27 am

Post by kishorenvkb »

Thanks
Post Reply