DSXchange

Hi,
I had the datastage job open. I lost the connection.
So I closed the datastage connection and opened the new connection.
When I try to open again, I get a message "Job Accessed by another user"

How do I open this job.

Thanks
Ketfos

You can release the lock from Director.

Hi,
I went to Director. Tried to release the lock for this job.
In the Process Window, it displays the context - Unavailable.

SO when I click on Release All after selecting this, nothing happens. It remains in the window display.

Ketfos

Hi ketfos,

To unlock the DataStage job, execute the following command:

UNLOCK USER <Userno> ALL

Martin

hi martin,
can you be more precise in your answer.what is meant by user no?Is there any way i can kill the individual job.if possible should i execute the command in the unix prompt or dsadministrator command line.comments appreciated
thanks

you can stop DS server check are there some processes still running kill processes and start DS server

Do not stop datastage unless the connection is terminated normally. There may be listners alive locking the port that may hold the shutdown.

Do a 'netstat' before shutdown to confirm that all listners are down. You are better-off removing this lock in isolation than to bring the engine down.

Hi,

In order kill any job.. you have give PID(process_id).. when any job or sequence is started is initiates a new process in Unix.. when the job is started you can see the job name with the processid.. if you want to kill or stop a job that is running(it is not advisable not kill through unix prompt be careful while executing this.. take a help of someone with unix knowledge)give kill -9 <processID> don't use -9 unless you don't have any other options.. hope this helps.. allready there were lot of queries about this.. do a search...

Thanks
Sudharsanan

Do not stop the Engine....Do not kill Unix processes....refer to topics here "how to unlock" and your answer will set you free....you can unlock via dssh or via Administrator command.....anyway its well documeted here...

Hi knowds,

Logon to DSAdmin(Make sure you have Admin Privilages) -> Choose Project -> Coomand Line -> run LIST.READU you will find Active Record Locks -> UNLOCK USER <userno> ALL or UNLOCK PID <pid no> ALL or
UNLOCK Inode <Inode no> ALL. Your job is Unlocked.

HaveFun
Martin