My DataStage Designer client froze while I was signed on as the dsadm user, so now I have two job that are locked. I know how to
UNLOCK USER ##### ALL
but the last time I did this for the dsadm user, I also brought down our media management system, which depends upon a couple connections kept open by the dsadm user. Oops.
How can I unlock only the jobs, without affecting the other dsadm processes?
$ ps -ef | grep dsadm
UID PID PPID C STIME TTY TIME CMD
dsadm 766006 6639832 0 13:08:34 - 0:00 dscs 4 32400 0
dsadm 1077252 8405240 0 Aug 05 pts/0 0:00 -ksh
dsadm 1597658 6070396 0 Aug 02 pts/3 0:00 -ksh
dsadm 4960504 766006 0 13:08:34 - 0:29 dsapi_slave 7 6 0
It's the processes started Aug 02 and Aug 05 that I need to preserve.
how to surgically unlock job locked by dsadm user
Moderators: chulett, rschirm, roy
I would recommend to activate the deadlock daemon (you can use search or read the documentation to get additional information on this subject). This will wake up ever n-minutes (default is 15) and clear up all these locks automatically, so there will no longer be a danger of release locks on processes that you don't want to touch.
In your case you can use the director -> cleanup resources to get rid of the jobs, you can identify them, as you already have, by pid. In your case it is pid 4960504 that you need to get rid of.
In your case you can use the director -> cleanup resources to get rid of the jobs, you can identify them, as you already have, by pid. In your case it is pid 4960504 that you need to get rid of.
</a>