datasatge中如何释放被他人占用的job

Removing locks when you receive the error:…Cannot get exclusive access …

1. Login to DataStage Administrator as an administrativeuser.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:

   LIST.READU

4. The last column is the item id. Look for item id’s like:

   jobname

This is the record you will want to unlock. Now you cannote the inode or user no, whichever uniquely identifies the record.

5. The unlock command is not available by default in theprojects. 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

Note: This only needs to be done the first time in eachproject.

6. To unlock by either INODE or User No use the commands:

UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL

Another approach :

1. telnet to DS server machine as ds administrative account(dsadm or root for example);
2. cd to $DSHOME;
3. source dsenv by “. ./dsenv”; (read as dot_space_dot_dsenv)
4. run “bin/uvsh” to enter TCL prompt;
5. run “>LIST.READU EVERY”, are you able to find any lock for the projectunder Active Record Locks? If yes, mark down the Userno for the command below;
6 run “>UNLOCK USER userno ALL”;
7. run “>LIST.READU EVERY” again to verify the lock for the user is gone;
8. repeat step 6 and 7 until all locks for the project is clear;
9. run “>LO” to exit TCL prompt.
10. try login to the project again.