My routines locked need to release them

Titto · Post by **Titto** » Thu Dec 22, 2005 9:08 am

Hi,

One of my routine is locked while i am tesing it and i went i kill the process from unix , before that i tried to logout from "Clean Up Resource" thru Director and it did not get logged out then i kill the process from Unix. But when i tried to open the routine it still says
" Routine in file DS_ROUTINES is locked by other user" - i am sure there are no other users using other than me.

How to check deadlock daemon is running or not ?

any help is appreciated!!

Thanks

ArndW · Post by **ArndW** » Thu Dec 22, 2005 9:20 am

The deadlock daemon is a process called "dslockd". You most certainly did a kill -9 which killed the pid but left the lock in DataStage. I'll just comment that many threads warn about doing this.

If your deadlock daemon is running then wait a couple of minutes and the lock will get released, the default interval is 15 minutes so that will most likely be the longest wait you will have.

If you do a "LIST.READU EVERY" from TCL you will see some link with the user being "unknown" - that's your lock.

Titto · Post by **Titto** » Wed Dec 28, 2005 3:57 pm

You are correct ArndW I did use Kill -9. It's been one week still my routines are locked... looks like Deadlock deamon is not running.
is they any other way to release.

thanks

ray.wurlod · Post by **ray.wurlod** » Wed Dec 28, 2005 5:01 pm

Search the forum for information about the UNLOCK command. You must have Administrator access to use this command.

Titto · Post by **Titto** » Thu Dec 29, 2005 8:16 am

I tried LIST.READU command then UNLOCK USER #### ALL command... I don't have lock management access to perform.
and looks like deadlock deamon is also not running!!!

chulett · Post by **chulett** » Thu Dec 29, 2005 8:18 am

Well... then have your Admin do it for you. Or have them start the deadlock deamon. Or both.