How to Unlock a job

[rupesh.datastage]

Hi,

I was working on one job, after sometime it was saying that it got locked by the specific user. That is my user only, how to unlock that job.

I dont have admin privileges.

Please advise,

[kandyshandy]

For my knowledge, i realized that Version 8.0 behaves a little different. Try doing a force compile for that job from designer, provided you are sure that you are the one who locked the job.

[rupesh.datastage]

For my knowledge, i realized that Version 8.0 behaves a little different. Try doing a force compile for that job from designer, provided you are sure that you are the one who locked the job.

**

when i open that job, it is saying it got locked and do you want to open a read only job. But i didnt see compile button enabled after seeing that job.

please advise...

[rupesh.datastage]

For my knowledge, i realized that Version 8.0 behaves a little different. Try doing a force compile for that job from designer, provided you are sure that you are the one who locked the job.

**

when i open that job, it is saying it got locked and do you want to open a read only job. But i didnt see compile button enabled after seeing that job.

please advise...

**

i have used :=

ps -ef | grep {job name}
cwd 610714 95100 0 09:30:41 pts/4 0:00 grep {jobname}

/home/whsdss/cwd > kill -9 95100

it is working now, is it a right thing to do ??

[kandyshandy]

Good to know that it has worked for you. You can kill, provided you are sure that you are the one who locked the job. ps -ef will show you which user has lock over the job.

For force compile of locked job/jobs, you may have to use multiple job compile option. I tried once and it worked for me.

[Nagaraj]

There is no question of compile or force compile when the job is locked.

You can go to the web console and check the connections in the active sessions window, and kill the session which is having your id as userid, the lock will be released.

Thanks

[chulett]

In other words:

is it a right thing to do ??

No.

[kandyshandy]

Nagaraj,
Rupesh told that he does not have ADMIN privilege. I wonder how can he kill the session from web console without having admin console?

[kandyshandy]

Nagaraj,
Rupesh told that he does not have ADMIN privilege. I wonder how can he kill the session from web console without having admin console?

[Nagaraj]

He can ask for admin to clear it and get it done easily.

[chulett]

Besides, advising anyone to "kill -9" anything is not the best thing to be doing. Maybe a "kill -15", but best to stick with established interfaces so everything is done correctly.

[kandyshandy]

I agree !!