好几个datastage job 都提示错误:cannot get exclusive access to job
Unlock DataStage Object
April 3rd, 2007
Just find a useful thread in IBM’s forum : How to unlock a job accessed by another user.
Removing locks when you receive the error: Cannot get exclusive access
1. Login to DataStage Administrator as an administrative user.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:
4. The last column is the item id. Look for item id’s like:
This is the record you will want to unlock. Now you can note the inode or user no, whichever uniquely identifies the record.
5. 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
Note: This only needs to be done the first time in each project.
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 project under 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.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/202861/viewspace-973054/，如需转载，请注明出处，否则将追究法律责任。