Job accessed by another user

[ketfos]

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

[Sainath.Srinivasan]

You can release the lock from Director.

[ketfos]

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

[martin]

Hi ketfos,

To unlock the DataStage job, execute the following command:

UNLOCK USER <Userno> ALL

Martin

[knowds]

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

[Luk]

you can stop DS server

Code: Select all

./bin/uv -admin -stop

check are there some processes still running

Code: Select all

ps -ef | grep dsslave (or dsapi)

kill processes and start DS server

Code: Select all

./bin/uv -admin -start

[Sainath.Srinivasan]

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.

[sudharsanan]

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

[trokosz]

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...

[martin]

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