Can the same DataSet be loaded by two Parallely running jobs

sidharth · Post by **sidharth** » Fri Sep 01, 2006 3:31 am

Hello All,
This is my first post in this forum. I am new to DataStage PX.
Thank You everyone for sharing your experience and views on Data Stage PX.

I have a query,

Can two Parallel jobs running parallely insert into the Same Data Set(Same Path, Same File Name, Append Mode)?
Will DataStage take care of locking and unlocking of datasets, or will it throw some error?

My Environment
--------------
* DataStage PX V7.5.1.A
* On AIX Unix Server

Thanks in advance for the explanation,

Regards,
Sidharth

ArndW · Post by **ArndW** » Fri Sep 01, 2006 3:50 am

Hello Sidharth,

that is good question indeed! I've not tried it but am fairly sure that this won't work. Have you tried to see what happens when you do this?

ray.wurlod · Post by **ray.wurlod** » Fri Sep 01, 2006 6:36 am

Welcome aboard. :D

A tantalizing question. Like Arnd it's not something I've attempted. Why not try it and let us know your findings?

sidharth · Post by **sidharth** » Fri Sep 01, 2006 8:04 am

Hi,
I did check this from my end.
I created two similar DS jobs and put them both in a sequencer.
The Sequencer was run such that both the jobs started at the same time.
The sequencer got succedded in the run. The sequencer job log shows a warning that Job1 successded with a warning.
I checked the dataset content to find that it had only the records inserted by DS Job2. Records tried to be inserted by Job1 does not exist in the dataset.

I am not convinced with the outcome, so thought of getting this confirmed by DS Gurus.

Thanks,
Sidharth

ArndW · Post by **ArndW** » Fri Sep 01, 2006 8:06 am

You confirmed that it won't work to me. Thanks!

emma · Post by **emma** » Fri Sep 01, 2006 9:38 am

What is your Job1 warning ? Let us see what he's saying.