How to release locking project ?

I'd found this error "ACCESS DENIED: Project currently locked. The project is currently locked by the Administrator. Try again later or see your administrator" and honestly speaking, it's very frustating and time consuming because I don't even know why it happened.


But there are some steps that might help you for solving this problems, there are:

1. cd to $DSHOME (/opt/IBM/InformationServer/Server/DSEngine in Linux or equivalent)
2. Edit the uvconfig file and change the following settings: MFILES=64, T30FILE=512, GLTABSZ=100 and RLTABSZ=100
3. Source dsenv if necessary (execute ". dsenv")
4. Stop the DSEngine by executing "bin/uv -admin -stop"
5. Apply the configuration changes by executing "bin/uvregen"
6. Start the DSEngine by executing "bin/uv -admin -start"

Hope it helps

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