Problem with locks

[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

[naveen19]

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

[pawel_janowski]

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

[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

[pawel_janowski]

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