Job Access Problem.

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Job Access Problem.

Post by admin »

Hi All,

When I tried to delete a job I am getting " is being used by another user".
But nobody is using that job. How to delete this the job?

Kindly reply with your suggestions.

Rgds,
Anbu


**************************Disclaimer************************************

Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confidential' and intended for use only by the individual
or entity to which it is addressed. You are notified that any use, copying
or dissemination of the information contained in the E-MAIL in any manner
whatsoever is strictly prohibited.

***************************************************************************
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Job Access Problem.

Post by admin »

Is the job opened by some in the designer window or
someone abnormally closed job designer window.
then you need to unlock the job to delete it


thanks

--- RAMAN ANBUCHELIAN
wrote:
>
> Hi All,
>
> When I tried to delete a job I am getting " Name> is being used by another user".
> But nobody is using that job. How to delete this the
> job?
>
> Kindly reply with your suggestions.
>
> Rgds,
> Anbu
>
>
>
**************************Disclaimer************************************
>
> Information contained in this E-MAIL being
> proprietary to Wipro Limited is
> 'privileged' and 'confidential' and intended for use
> only by the individual
> or entity to which it is addressed. You are
> notified that any use, copying
> or dissemination of the information contained in the
> E-MAIL in any manner
> whatsoever is strictly prohibited.
>
>
***************************************************************************


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Job Access Problem.

Post by admin »

Hi Anbu,

I think you shut down Designer not correct while having opened the job you
mentioned. That's why Datastage thinks the job is still in use, the session
didn't clear the look.

You have to run the director. Choose 'job' in the menu and then choose
'cleanup resources'. Press show all, select a job or process en choose for
clear lock. When different users log on with the same user name, it could be
that you un lock jobs they are using, so look out what you do!

Good luck!

Wim van Dommelen.

-----Oorspronkelijk bericht-----
Van: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Verzonden: dinsdag 21 oktober 2003 11:38
Aan: datastage-users@oliver.com
Onderwerp: Job Access Problem.



Hi All,

When I tried to delete a job I am getting " is being used by
another user".
But nobody is using that job. How to delete this the job?

Kindly reply with your suggestions.

Rgds,
Anbu


**************************Disclaimer************************************

Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confidential' and intended for use only by the individual
or entity to which it is addressed. You are notified that any use, copying
or dissemination of the information contained in the E-MAIL in any manner
whatsoever is strictly prohibited.

***************************************************************************


****************************DISCLAIMER***********************************
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere aansprakelijkheid uit die voortvloeit uit electronische verzending.

This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Fortis rules out any and every liability resulting from
any electronic transmission.
*******************************************************************************
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Job Access Problem.

Post by admin »

Hello --

This is a very common issue and could be found doing a search on the forums.

Here it is in summary -- this is an undocumented feature and not supported
by Ascential. The directions are provided using the UNIX server version.

Go to $dshome (which should be .../DSEngine)

bin/uvsh

LOGTO [project name where the job is]

DS.TOOLS

Select 5.

Select 4. Identify the job listed.

Select 1. (4 only shows the last 5 digits of the PID, use this option to
show the entire PID. This is a known bug with at least 6.0.1, but this,
again, is an undocumented feature.)

Select 7.

Enter the PID identified.

Press enter/return key a few times to return to '>'

Type QUIT

* * *

You're done.

The above advice carries no guarantee of success, and is not a promise by
myself, blah blah blah. The above advice carries risk of killing jobs that
you do not want to have killed. (KILL in UNIX term is stopping a process
from running. If you have no idea what I'm talking about here, get an UNIX
guru involved).

-T.J.

>When I tried to delete a job I am getting " is being used by
>another user".
>But nobody is using that job. How to delete this the job?

_________________________________________________________________
Add MSN 8 Internet Software to your current Internet access and enjoy
patented spam control and more. Get two months FREE!
http://join.msn.com/?page=dept/byoa
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked