Simultaneous reading of a dataset

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
sswarup
Participant
Posts: 6
Joined: Fri May 28, 2004 6:11 am

Simultaneous reading of a dataset

Post by sswarup »

Hi,
Can two independent jobs read one dataset simultaneously?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Maybe, maybe not.

For a start, both jobs would have to run on exactly the same set of processing nodes. It may also be necessary to specify those in the same order (for example use the same configuration file for each job), so that the partitioning algorithm works the same way.

I don't imagine you would have any issues with locking, since both open the dataset for reading.

Why not try it, and let us know?
Last edited by ray.wurlod on Thu Oct 28, 2004 3:04 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dsxdev
Participant
Posts: 92
Joined: Mon Sep 20, 2004 8:37 am

Post by dsxdev »

Hi

Rightly said by Ray it may be possible to read same Dataset by two different jobs if you specify same processing nodes This is necessary because Data in Dataset recides on Nodes.
Happy DataStaging
Post Reply