Page 1 of 1
Problem with locks
Posted: Tue Apr 15, 2008 3:33 am
by pawel_janowski
Hi!
I can't open some jobs in the Designer because the system claims that they are being accessed by another user. In the Director I can see that there are Record locks on those jobs (using Resorce Cleanup), but the processes which are reported to hold those locks do not exist in the system. Trying to logout those processes or releasing all locks - from inside the Director/Resource Cleanup - has no effect. Is there another way to release job locks?
Regards.
Pawel Janowski
Re: Problem with locks
Posted: Tue Apr 15, 2008 3:52 am
by naveen19
pawel_janowski wrote:Hi!
I can't open some jobs in the Designer because the system claims that they are being accessed by another user. In the Director I can see that there are Record locks on those jobs (using Resorce Cleanup), but the processes which are reported to hold those locks do not exist in the system. Trying to logout those processes or releasing all locks - from inside the Director/Resource Cleanup - has no effect. Is there another way to release job locks?
Regards.
Pawel Janowski
Hi Pawel,
Get the process id from datastage director and kill session using in comand prompt
Regards
Naveen.K
Re: Problem with locks
Posted: Tue Apr 15, 2008 3:58 am
by pawel_janowski
naveen19 wrote:
Hi Pawel,
Get the process id from datastage director and kill session using in comand prompt
Regards
Naveen.K
Hi,
It is impossible, cause (as I wrote before) those processes do not exist in the system (the processes with pids shown by the Director) - that's why I was very surprised that it is possible that non-existing processes can hold locks.
Regards.
Pawel Janowski
Posted: Tue Apr 15, 2008 4:15 am
by sunayan_pal
you can achieve this by the command prompt in the administrator.
there find out all the locked presently held by various project in that server .
it will list all the various locks held on object level.
get the user id and release all the locks from that userid
Posted: Tue Apr 15, 2008 5:11 am
by pawel_janowski
sunayan_pal wrote:you can achieve this by the command prompt in the administrator.
there find out all the locked presently held by various project in that server .
it will list all the various locks held on object level.
get the user id and release all the locks from that userid
Thanks, works fine.
Regards.
Pawel