Partition method behind Auto Partition.

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
Ravi.K
Participant
Posts: 209
Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore

Partition method behind Auto Partition.

Post by Ravi.K »

My Job design is as follows.

Sequential File --> Transformer --> Sequential File

At Transformer level the partition method set as Auto Partition. is it possible to find what partition method was used for parallel execution by using SCORE or Suggest any alternatives. Please find the Job score as follows.

ds0: {op0[1p] (sequential Sequential_File_0)
eAny<>eCollectAny
op1[4p] (parallel APT_TransformOperatorImplV0S2_Functions_TEST_Transformer_2 in Transformer_2)}

ds1: {op1[4p] (parallel APT_TransformOperatorImplV0S2_Functions_TEST_Transformer_2 in Transformer_2)
>>eCollectAny
op2[1p] (sequential APT_RealFileExportOperator in Sequential_File_1)}


It has 3 operators:

op0[1p] {(sequential Sequential_File_0)
on nodes (
node1[op0,p0]
)}
op1[4p] {(parallel APT_TransformOperatorImplV0S2_Functions_TEST_Transformer_2 in Transformer_2)
on nodes (
node1[op1,p0]
node2[op1,p1]
node3[op1,p2]
node4[op1,p3]
)}
op2[1p] {(sequential APT_RealFileExportOperator in Sequential_File_1)
on nodes (
node2[op2,p0]
)}
It runs 6 processes on 4 nodes.
Cheers
Ravi K
ppgoml
Participant
Posts: 58
Joined: Mon Aug 20, 2007 11:00 pm

Post by ppgoml »

I believe it's round robin in your case
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes, the tokens that describe partitioning are like eAny, eHashed in the score. The rules about what (Auto) gives have been posted in the past on DSXchange. You can Search for them.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ravi.K
Participant
Posts: 209
Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore

Post by Ravi.K »

Thanks Ray. Now i could understand the Job score.
Cheers
Ravi K
Post Reply