about general dsjob

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
sumeet
Premium Member
Premium Member
Posts: 54
Joined: Tue Aug 30, 2005 11:44 pm

about general dsjob

Post by sumeet »

I have a simple problem :

While I was working on a dsjob , my pc got hung and I had to restart the system.

Now after I restarted it , since then I havent been able to open the job I was working on. Whenever I open it , [b]it says job is being accessed by another person.[/b]

I tried closing and opening the datastage number of times. I refreshed DS quite a few times and I am pretty sure that no one else is accessing the job.

Is there anyway in DS to know who is the person accessing the job in the network. I tried in director, manager (usage analysis).

Thanks
Sumeet
trammohan
Participant
Posts: 47
Joined: Thu Nov 13, 2003 12:47 pm

Post by trammohan »

There are two ways to release the locks..

1. In director release the resources for that job.

2. at command level on server side use UNLOCK user # all to release the job
sumeet
Premium Member
Premium Member
Posts: 54
Joined: Tue Aug 30, 2005 11:44 pm

Hung Job

Post by sumeet »

I got it back going.

Thanks anyways Mohan

Sumeet
kuppucv
Participant
Posts: 1
Joined: Tue Dec 07, 2004 6:30 am

Re: about general dsjob

Post by kuppucv »

sumeet wrote:I have a simple problem :

While I was working on a dsjob , my pc got hung and I had to restart the system.

Now after I restarted it , since then I havent been able to open the job I was working on. Whenever I open it , it says job is being accessed by another person.

I tried closing and opening the datastage number of times. I refreshed DS quite a few times and I am pretty sure that no one else is accessing the job.

Is there anyway in DS to know who is the person accessing the job in the network. I tried in director, manager (usage analysis).

Thanks
Sumeet
1.In director go to job--> cleanup resources.
2.click show all radio button in both processes window and locks window.
3.Note the process id of the job locked in locks window.
4.locate the process id from step 3 in processes window and highlight it
5.press the logout button.

Now if you go back to designer you will be able to open the job.
Post Reply