A number of my jobs are locked due to broken connections. I have the deadlock deamon process running every 15 mins which I expected would clean up the locks but it does not (any reason why it does not unlock jobs). When I do the ps -ef command, I see the following processes
Do I need to kill these processes for the deamon to unlock the jobs?xxxxxx 819514 327918 0 Oct 24 - 0:00 dsapi_slave 7 6 0
xxxxxx 835862 278688 0 Oct 24 - 0:00 dsapi_slave 7 6 0
Also, I don't see the locks in the director's Job Resources screen unless I select the "Show All" under the "Locks" section and I cannot release any of the locks. when I select the "Show by Job", nothing shows up. What is the correct way using the Job Resources function/utility. I was unable to find any documentation.
I've also read on one of the forums to use the UNLOCK user user# ALL. When I issue this command from the administrator, I get the "Verb not found in your VOC" error. Do I have to be an administrator to issue this command.
What else can I do? short of issuing, the kill -9 command, then restarting the datastage server to reset locks and connections. Note: I am not the administrator on this box and don't have access to the dsadm userid.
Also, is there a notion of Administrator group in DataStage? Can anybody else start & stop the server besides the dsadm.
Thanks.
Suresh