DSXchange

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

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 possi...

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 ...

Hi!
The problem was outside of DS - the stored procedure was sometimes inefficient.

Pawel

Thx, Details about the job design: - the overall design is very simple - I want to load data from flat files to staging tables and then redistribute data to target tables using the stored procedure (without any parameters) - and so I use STP stage (at the end of that sequence) - in a job activity I ...

Hi! I've got very stupid problem using STP stage - when I use the STP stage to call an Oracle procedure the procedure (probably) hangs or maybe it's better to say runs forever. When I call the same procedure (which takes no paramters and just makes some selects on database) from Oracle client it run...