Job is Locked

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
praburaj
Premium Member
Premium Member
Posts: 133
Joined: Thu Jun 30, 2005 1:26 am
Location: philippines

Job is Locked

Post by praburaj »

Hai,

I have tried to view data in odbc. Unfortunately the job has been locked. I went to director and select cleanup resources then i have select the corresponding job id and i have pressed logout button. But, that job is not log out. Even i have tried job by process and i have selected RELEASE JOB ALL. Even it didn't release the job. I dont know how to logout the job. Can anyone help me How to do that? :shock:

Note: The id is same for (19144) for different jobs (Stg_Surveys and copy_stg_surveys_1)

Regards,

prabu
Sakthi_Sst
Participant
Posts: 36
Joined: Wed Aug 09, 2006 12:18 am
Location: Chennai

Post by Sakthi_Sst »

Hi Prabhu,

Try this to unlock the Job.

1.Go to Administrator->Projects
2.Select your project click Command
3.Type 'ds.tools' click execute.
4.Type 4
5.Type 7
6.It would ask you to enter the Pid#
7.Enter your Pid and enter

This has worked for me.Update if it has worked for you.

Thanks,
Sakthi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Make sure you choose the PID, not the user number.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply