how to distribute the records amoung the nodes..

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
kannan_ayyanar
Premium Member
Premium Member
Posts: 19
Joined: Sat Apr 17, 2010 10:28 am
Location: Navi Mumbi

how to distribute the records amoung the nodes..

Post by kannan_ayyanar »

i am new to the concept of partition. please help me...

4 nodes are defined in server...

how could i distribute the input records to the 4 nodes... for example 1000 rows are coming from input, i would like to distribute 250 rows to each node... is it possible to achieve this.. if this kind of question is already raised in this forum... please give me the link.. i searched in this forum but i couldn't find that..

thanks in advance...
Kannan
kannan_ayyanar
Premium Member
Premium Member
Posts: 19
Joined: Sat Apr 17, 2010 10:28 am
Location: Navi Mumbi

document...

Post by kannan_ayyanar »

if any one having good document which explains very basics about partitioning. let me know... i searched in google.. i didnt get what i expected....


thanks in advance...
Kannan
dsa
Participant
Posts: 37
Joined: Sun Oct 10, 2010 7:52 am

Post by dsa »

parallel job dev guide explains types of partitioning. Depending upon your requirement, you might want to go for round robin or hash or modulus or random partitioning to achieve the same.
kannan_ayyanar
Premium Member
Premium Member
Posts: 19
Joined: Sat Apr 17, 2010 10:28 am
Location: Navi Mumbi

Post by kannan_ayyanar »

job is simple... sequential file as input and output... and transformer in between.. ok if i go for a round robin partition in transformer.. how can i check the count of record processed in each node... ?
Kannan
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

From monitor.
Marley777
Premium Member
Premium Member
Posts: 316
Joined: Tue Jan 27, 2004 3:26 pm

Post by Marley777 »

where in monitor can you see how many records were processed for each node?

Wondering if there is a break down per stage?

Example

Node1 processed 4 records
Node2 processed 7 records
etc...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Right click in Monitor background area and enable "Show instances". Parallel stages will show as x 4 if collapsed, or as four separate instances if expanded.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply