How to create UNLOCK statement in VOC
1. Ask the person (login Id) having the issue to get out of DataStage all together…
2. In Administrator click on the Command button
3. Execute LIST.READU and note the ALL Inode and User No for the Login Id that is having the issue….
4. Execute SET.FILE UV VOC UV.VOC
5. Execute COPY FROM UV.VOC TO VOC UNLOCK
6. Execute UNLOCK INODE <Inode Number> ALL and/or UNLOCK USER <user no> ALL
7. Repeat 6 for all Inodes and User Nos
8. Execute 3 and see if the Login Id is gone (if not do 6 until it happens)
9. Call the person and your all set…..
10. Or run the dsdlockd.config daemon by editing this file, changing start=0 to start=1 . It will start next time DataStage is started. This will automatically do the above periodoically.