How to release lock on your datastage job?

Sometimes you can have condition when your job is locked eventhough all users have been disconnected from the session. There are few things that you can do when you have this condition:

• Open DataStage Administrator Client
• Choose your project
• Click Command Button and type:

1. LIST.READU <For listing all active locked session>
2. SET.FILE UV VOC UV.VOC 
3. COPY FROM UV.VOC TO VOC UNLOCK
4. UNLOCK INODE <INode Number you want to unlock> ALL
5. Or, UNLOCK USER <User Number you want to unlock>

• Repeat all step until the job is released.

Or you can release it with Delete all records from XMETALOCKINFO table