Job access by other and cant unlock

swades · Post by **swades** » Sun Jan 21, 2007 6:48 pm

When I am opening the job it says that the Job is being access by other user but when I see in Director for cleanup resource it says me :

ERROR: Cannot find any process numbers for stages in job hir_lre_aro_side

I tred in Admin. also by 'ds.tools' but it also giving me same massage.

How can I resolve this ?

Thanks in advance

narasimha · Post by **narasimha** » Sun Jan 21, 2007 7:01 pm

This has been dealt with many times.
Check this one for a start

swades · Post by **swades** » Sun Jan 21, 2007 7:41 pm

Thanks for posting link that resolve my problem. I used following from that post:

Click on ok, and under locks, select Show All.
You might find your job. Note down the PID. Select the PId from Process block.
Now again click on show by process under Locks.
Click on release All.
Try to use dsadm user id

Thanks

narasimha · Post by **narasimha** » Sun Jan 21, 2007 8:37 pm

On reading one of Ray's post, got to know that the good thing about 8.0 will be that - you get to know who has actually opened it.
So you tell that person to close it, rather than doing the clean up.
But I guess this situation is still going to continue, if the job does not get closed gracefully.

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 8:54 pm

If a job was locked under your id, someone else cannot get rid of it. Only you have to go in with your id and unlock it. "Who unlocked the job" can also be determined in the present versions by going into the cleanup resources and bringing up current active threads. It will tell you the id right there.

kumar_s · Post by **kumar_s** » Sun Jan 21, 2007 9:13 pm

Irrespective of the users, dsadm will have the full control of that.

narasimha · Post by **narasimha** » Sun Jan 21, 2007 9:14 pm

DSguru2B wrote:"Who unlocked the job" can also be determined in the present versions by going into the cleanup resources and bringing up current active threads. It will tell you the id right there.

Nice to know, I did not know we had a way to find out "Who unlocked the job".
I dont have access to Datastage right now, need to look into that feature.

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 9:15 pm

O yea, forgot to add that. Thanks kumar.

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 9:16 pm

narasimha wrote: Nice to know, I did not know we had a way to find out "Who unlocked the job".
I dont have access to Datastage right now, need to look into that feature.

And in the DataStage admin, you can type LIST.READU to pull up the same info. Even that will give you a list of all the live/locked threads along with pid's and user id's.

narasimha · Post by **narasimha** » Sun Jan 21, 2007 9:21 pm

DSguru2B wrote:
narasimha wrote: Nice to know, I did not know we had a way to find out "Who unlocked the job".
I dont have access to Datastage right now, need to look into that feature.
And in the DataStage admin, you can type LIST.READU to pull up the same info. Even that will give you a list of all the live/locked threads.

I am familiar with finding the locked jobs, I was more interested in option of getting to know how to get to know who unlocked the job.

kumar_s · Post by **kumar_s** » Sun Jan 21, 2007 9:26 pm

Narasimha - LIST.READU brings user id as well. Wont it?

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 9:28 pm

Yup. It sure will.

narasimha · Post by **narasimha** » Sun Jan 21, 2007 9:36 pm

Guys, may be I am missing somethiing here.
LIST.READU gives us the the list of locked jobs, user-id, ... ,... - Agree.

It does not give you anything as to "who unlocked the jobs", right?

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 9:44 pm

User Id tells you that.

kumar_s · Post by **kumar_s** » Sun Jan 21, 2007 9:44 pm

Now I see the reason of couple of your previous post. Missed that prominent word. I should be Locked rather than Unlocked.