Lock on project

myukassign · Post by **myukassign** » Sat Aug 02, 2008 3:11 am

When I access my datastage project using any of the client, I am getting an error.

"Access Denied! Project is locked"

but I can access some other projects in the same server.

Can anyone help me how to release a lock on the project?

ArndW · Post by **ArndW** » Sat Aug 02, 2008 5:45 am

This might have happened if an admistrative lock was taken and not released (this could happen if the process aborts). Do you have the DataStage deadlock daemon running? If not, it would make sense to start it in order to see if it takes care of that lock. If that doesn't work, then I can think of 2 options - the quickest is to restart DataStage, the second it to see what locks are taken (go to the TCL prompt and enter "LIST.READU EVERY"). Unless you know what you are doing, playing with locks directly can have negative impact, so I would recommend doing the first two options first.

You can start the deadlock daemon by ensuring you have execute ". ./dsenv" in the $DSHOME directory and then then executing

Code: Select all

$DSHOME/bin/dsdlockd -p

myukassign · Post by **myukassign** » Sat Aug 02, 2008 6:15 am

I restarted the server and its done

Thnk u