Job is locked by an user
Moderators: chulett, rschirm, roy
Job is locked by an user
This is my job is locked against my own id, though its not open in my DataStage application window. Do any one knows, how to get rid of this lock, from the job.
Thanks with regards,
videsh.
videsh.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
No, you cannot UNLOCK other processes without being dsadm or higher.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
hi videsh,
if u have admin privileges then u can do it. but anyways it is not a big deal for ur admin.
if u don't have admin in ur group then u can follow the steps given this forum.
if not i will make ur job easy
Login to DataStage Administrator as an administrative user. Go to the
Command Prompt for that Project.
Execute: LIST.READU
The last column is the item id. Look for item id's with the job name. Now
you can note the inode or
user no, whichever uniquely identifies the record.
The unlock command is not available by default in the projects. To create
an entry to use unlock execute the following two commands:
>SET.FILE UV VOC UV.VOC
>COPY FROM UV.VOC TO VOC UNLOCK
To unlock by either INODE or User No use the commands:
UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL
bye
paddu
if u have admin privileges then u can do it. but anyways it is not a big deal for ur admin.
if u don't have admin in ur group then u can follow the steps given this forum.
if not i will make ur job easy
Login to DataStage Administrator as an administrative user. Go to the
Command Prompt for that Project.
Execute: LIST.READU
The last column is the item id. Look for item id's with the job name. Now
you can note the inode or
user no, whichever uniquely identifies the record.
The unlock command is not available by default in the projects. To create
an entry to use unlock execute the following two commands:
>SET.FILE UV VOC UV.VOC
>COPY FROM UV.VOC TO VOC UNLOCK
To unlock by either INODE or User No use the commands:
UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL
bye
paddu
Re: Job is locked by an user
There is One more simple Mechanisam for this check in your DataStage Director under Jobs Menu see if Cleanup Resources is Enabled ( If not enabled then you can't do. This can enabled in Adminstrator) if it is Eanabled click CleanUp Resources.
Job Resources Window opens
On the Top part you find your Userid and select it
On the Bottom part all the Sessions you are open will be displayed Click on the one whick you this is Locked and Press Release all button on Bottom right conner
Please see that your are release your Job only ( If all the User are using the Same login Id You have to Browse for your Job Name)
Hope this might help you
Job Resources Window opens
On the Top part you find your Userid and select it
On the Bottom part all the Sessions you are open will be displayed Click on the one whick you this is Locked and Press Release all button on Bottom right conner
Please see that your are release your Job only ( If all the User are using the Same login Id You have to Browse for your Job Name)
Hope this might help you
ram1899