Unable to kill a process, file locked
Posted: Tue Oct 30, 2007 12:07 pm
First thank DataStage gurus here, helped me resovled a lot of issues, I am totally new to DataStage.
This is my first post here. Please help.
What happened was after I stopeed a job, I couldn't open a sequential file in target, here was what I did:
I stopped my job by clicking on stop button in Director.
Then I tried to open the target sequential file, it's said "The process cannot access the file because it is being used by another process".
So I opened Cleanup Resources in DataStage Director, the process show by job is:
PID Context User Name Last Command Processed
8236 Aggregator_14(Running) Transformer_1(Running) UserName Unavailable
I tried to use Logout, it couldn't kill the job.
On Job Resources locks, I clicked on Show All, no locks associated with this PID.
Then I telnet to the server, LOGTO UV account, then LIST.READU
There was no lock on this job, so I couldn't UNLOCK anything.
Then I used DS.TOOLS, interesting the option for Administer processes/locks is 4 instead of 5 people mentioned in this forum. But anyway, I chose option 4, then option 7 Clear locks held by a process, entered PID 8236, no lock on this process at all.
Then I ran PORT.STATUS, PID 8236 shows up as a phantom. Not sure how to kill this PID since our server is on Windows.
I searched through the forum, the experts here suggested to start the dsdlockd demeon, so I changed the dsdlockd.config file, put start=1, and restarted the DataStage Services. Acutally I restarted Services twice. First time just waited for 30 seconds, second time I waited for 15 minutes to start all DataStage Services. I can see dsdlockd.exe running through task manager.
Unfortunally the PID is still showing up on Job Resources, and I have no idea how to kill it.
The only thing I can think of is to restart the server, but I don't want to do this everytime there is a lock happening like this.
Please help!
This is my first post here. Please help.
What happened was after I stopeed a job, I couldn't open a sequential file in target, here was what I did:
I stopped my job by clicking on stop button in Director.
Then I tried to open the target sequential file, it's said "The process cannot access the file because it is being used by another process".
So I opened Cleanup Resources in DataStage Director, the process show by job is:
PID Context User Name Last Command Processed
8236 Aggregator_14(Running) Transformer_1(Running) UserName Unavailable
I tried to use Logout, it couldn't kill the job.
On Job Resources locks, I clicked on Show All, no locks associated with this PID.
Then I telnet to the server, LOGTO UV account, then LIST.READU
There was no lock on this job, so I couldn't UNLOCK anything.
Then I used DS.TOOLS, interesting the option for Administer processes/locks is 4 instead of 5 people mentioned in this forum. But anyway, I chose option 4, then option 7 Clear locks held by a process, entered PID 8236, no lock on this process at all.
Then I ran PORT.STATUS, PID 8236 shows up as a phantom. Not sure how to kill this PID since our server is on Windows.
I searched through the forum, the experts here suggested to start the dsdlockd demeon, so I changed the dsdlockd.config file, put start=1, and restarted the DataStage Services. Acutally I restarted Services twice. First time just waited for 30 seconds, second time I waited for 15 minutes to start all DataStage Services. I can see dsdlockd.exe running through task manager.
Unfortunally the PID is still showing up on Job Resources, and I have no idea how to kill it.
The only thing I can think of is to restart the server, but I don't want to do this everytime there is a lock happening like this.
Please help!