Unable to create file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sonia jacob
Participant
Posts: 122
Joined: Mon Jul 05, 2004 1:33 pm
Location: MA

Unable to create file

Post by sonia jacob »

Hi,

My job creates a exel and flat file.
I had to stop the job in the midst. But now when I run the job again it gives the error that the files are being used by another user. And the job aborts.

The files cannot be accessed or deleted either. Looks like some process of the job that was stopped is still holding to files.

Any suggestion as to how to fix it.

Sonia
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Reboot your server. Sorry, your locks are probably being held by Windoze, make sure you don't have any virus software running on the server.
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
prabu
Participant
Posts: 146
Joined: Fri Oct 22, 2004 9:12 am

Re: Unable to create file

Post by prabu »

sonia jacob wrote:Hi,

The files cannot be accessed or deleted either. Looks like some process of the job that was stopped is still holding to files.
that "some process" is the previous process used for creating the file. DS is sensitive in case of file locks.

1) Kill all the process using Windows taskManager.
2)Goto DS Director
Job -> Cleanup Resources ->Locks (show all) .
select the job and ReleaseAll
Post Reply