Page 1 of 1

Problem with CLeaning up Resources

Posted: Mon Jul 11, 2005 8:04 pm
by vgaindhar
Our DataStage server was shutdown while my job was open in Designer.

Now when I open the job in Designer, it comes up with error -

"Job Jxxxxxx is being accessed by another user."

I go into Director and try to CLeanup Resources but cannot see my job. How do I access my job again in Designer. I cannot see any corresponding job running in UNIX as well.

I am told there is a direct command in DS Manager to clear the job if we cannot do so in Director.

Any help is appreciated.

Vipin

Posted: Mon Jul 11, 2005 8:18 pm
by Kryt0n
Was it a case of not seeing any jobs or just not the job you were interested in? Make sure you select the "Show All" radio button for Processes. This is one that throws me ocassionally!

Check out Director Guide->Job Administration->Cleaning Up Job Resources for the process to follow (up to clear status file).

Good luck!

DataStage Director not Releasing Locks

Posted: Mon Jul 11, 2005 8:55 pm
by vgaindhar
I cannot see my jobname in Processes. But I can identify my process by looking at all Locks, then selecting the Process FOLLOWED BY lOCKS(SHOW By Process). This shows me 3 Locks related to the process identified (The Description of this process says 'Unavailable') . I click on 'Release All' . But the jobs are still there on refresh. Is this an access issue with my userId. (I am able to click on 'Release All' button). I would think I should be able to release locks on my own jobs.
+++++++++++++++++++++++
Kryt0n wrote:Was it a case of not seeing any jobs or just not the job you were interested in? Make sure you select the "Show All" radio button for Processes. This is one that throws me ocassionally!

Check out Director Guide->Job Administration->Cleaning Up Job Resources for the process to follow (up to clear status file).

Good luck!

Posted: Tue Jul 12, 2005 1:27 am
by ray.wurlod
The lock is held by a defunct process, which is why you're not seeing it in Cleanup Resources.

You will need to login on the server, use list_readu (from UNIX) or LIST.READU (from dssh) to find out who's got the lock, and unlock that particular lock using the administrator-only command UNLOCK from the UV account.

I prefer the UNIX list_readu because I can pipe its output through grep, for example

Code: Select all

$DSHOME/bin/list_readu | grep jobname

Posted: Tue Jul 12, 2005 2:14 am
by kerensho
Hello vgaindhar,

In the Administrator there is a definition if you can "admin from director" - which means you will be able to see the jobs in "cleanup resource".
Still, if you do not have the permissions to do so, you can press this button a million times and it won't do a thing.
The face that you can physically press it is not important...

Keren

Posted: Tue Jul 12, 2005 4:43 am
by Sainath.Srinivasan
If nothing works, bounce DS server.