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
Problem with locks
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Thu Mar 27, 2008 7:18 am
Problem with locks
Pawel Janowski
Re: Problem with locks
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
-
- Participant
- Posts: 6
- Joined: Thu Mar 27, 2008 7:18 am
Re: Problem with locks
Hi,naveen19 wrote:
Hi Pawel,
Get the process id from datastage director and kill session using in comand prompt
Regards
Naveen.K
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
Pawel Janowski
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
-
- Participant
- Posts: 6
- Joined: Thu Mar 27, 2008 7:18 am
Thanks, works fine.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
Regards.
Pawel
Pawel Janowski