read and write to same seq file

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
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

read and write to same seq file

Post by samsuf2002 »

Hi All
i am running a job which has two seq files 1 and 2 passing through CDC and the output file is pathed same as seq file 1 its working fine but i want to knw is it the right way will it be a problem later like deadlock or something.any suggestions will be appreciated
hi sam here
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

If you have any simultaneous reading and writing to the same file you will have issues. Because your job has a syncronization point ahead of the output to the file, this doesn't necessarily occur. It's best to avoid your design anyway because you lose re-start capability, as you've destroyed the original file.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's dangerous. A better approach would be output to file 3 then, after the job has completed, delete file 1 and rename file 3 to file 1.[/i]
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