DSXchange

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.

Search for 'UNLOCK' in this forum.

I have tried following command :

unlock all myuserid #

But I am getting an error messgae as,
'Insufficient privileges to perform lock maintenance.'

I am not an admin, still can I unlock?

No, you cannot UNLOCK other processes without being dsadm or higher.

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

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