File Update & Delete in between job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

File Update & Delete in between job

Post by karthi_gana »

All,

What will happen if the file (which is currently in use by datastage) got updated or deleted ?
Karthik
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What do you mean by "in use"? Most operating systems don't allow a file opened for writing (for example by DataStage) to be written to by any other process. Most operating systems implement NR1W (any number of readers OR one writer) locking on files. On that basis, if DataStage has the file open, no other application can change it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Why not try it and see? Create a small test case, put it through the wringer and let us know.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply