How to run a sequential file in parallel mode?

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
adityavarma
Premium Member
Premium Member
Posts: 104
Joined: Thu Jul 12, 2007 11:32 pm
Location: Canada

How to run a sequential file in parallel mode?

Post by adityavarma »

Hi ,

How to run a sequential file in parallel mode ? in which mode will the sequential file run?

Thanks in Advance

Aditya
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

DataStage does not "run" files. Do you mean "read" or do you mean "write"? By default each operation is sequential. However parallel reading is possible.

Parallel writing to one file is prohibited, not by DataStage but by the operating system.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
devidotcom
Participant
Posts: 247
Joined: Thu Apr 27, 2006 6:38 am
Location: Hyderabad

Post by devidotcom »

You have an option of "Read from Multiple Nodes" or "Number of Readers per node".

Devi
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

Post by Minhajuddin »

It's funny that if "Number of readers per node" is set to "n" it doesn't run "n" readers per every node. It actually reads using "n" readers on just one node.
I guess the guys at Ascential didn't name it properly, It should have been "Number of readers per ONE node" :lol:

I know I am not answering the question, I was just amused when I found this behavior
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

True if you have only one File property. Try it with two File properties.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jassu
Premium Member
Premium Member
Posts: 7
Joined: Wed Dec 03, 2008 4:13 am
Location: USA

Post by jassu »

Will the delimited file also be read in parallel when the number of readers per node is set to a value > 1. I have seen the document specifying that this option is for fixed length file.
jseclen
Participant
Posts: 133
Joined: Wed Mar 05, 2003 4:19 pm
Location: Lima - Peru. Sudamerica
Contact:

Re: How to run a sequential file in parallel mode?

Post by jseclen »

There is a other way.

You split your input file in 4 small files (for example) and deinfe in the Sequential File stage the File Pattern = FileName*.

Assume your server has 4 nodes, when the job run each node read a one file and processing in parallel mode.
Saludos,

Miguel Seclén
Lima - Peru
Post Reply