Routine gets locked
Moderators: chulett, rschirm, roy
Routine gets locked
I executed a job and the job got stuck while executing a routine. When i tried to stop the xecution of the job, it did'nt happen. So, i used "clean up resources" option and released all processes for that job. Now, i can compile the job again. But , when i tried to open the routine , it says it is locked. How to release the lock for a routine. In director , we can only unlock jobs.But what about routine? How can we unlock a routine.
The next day when i came , i observed the lock on routine is released. I don't know how it happened.
The next day when i came , i observed the lock on routine is released. I don't know how it happened.
Aim high
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If DataStage had been restarted, all locks are released.
If your server has the DataStage deadlock daemon (dsdlockd) running, it will clean up locks held by defunct processes.
An Administrator might also have released the lock that was held on the routine in order to perform an export of the project.
If your server has the DataStage deadlock daemon (dsdlockd) running, it will clean up locks held by defunct processes.
An Administrator might also have released the lock that was held on the routine in order to perform an export of the project.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hai ray.wurlod , thanks for your reply , how can we know deadlock deamon is running on server, how can an administrator release the lock for a routine.Can u explain this pls
Hai lynnliu thanks for your reply,
Only for jobs, we can get process id in Director . But can we get process id for routines in Director using clean up resources option,
Hai lynnliu thanks for your reply,
Only for jobs, we can get process id in Director . But can we get process id for routines in Director using clean up resources option,
Aim high
Search this forum for unlocking jobs. Also look for "DS.TOOLS". Your function is just an object in the lock table, it will show up on the lock listing and you can release it.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
To determine whether the DataStage deadlock daemon is running on a UNIX machine execute the UNIX command
If it's running you'll learn its process ID; if it's not running the report will be empty.
Edit the $DSHOME/dsdlockd.config file to enable auto-start of the deadlock daemon when DataStage starts.
(On Windows servers look for dsdlockd among the processes in Task Manager.)
Code: Select all
ps -ef | grep dsdlockd | grep -v grep
Edit the $DSHOME/dsdlockd.config file to enable auto-start of the deadlock daemon when DataStage starts.
(On Windows servers look for dsdlockd among the processes in Task Manager.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
We can get process id for routines in Director using clean up resources option. i have done that many times.
There are two kind of list form in Jobs Resources window-----"processes" and "locks". click "show all" in locks, you can find all the locked routines and jobs name list with pid#, and then "show all" in processes,find the that pid#, log out it
Thanks
There are two kind of list form in Jobs Resources window-----"processes" and "locks". click "show all" in locks, you can find all the locked routines and jobs name list with pid#, and then "show all" in processes,find the that pid#, log out it
Thanks
Our Deadlock Daemon takes up an abnormally large amount of CPU while jobs are running. Is this normal? Does that indicate some type of configuration issue or possibly a tuning need? Any information would be greatly appreciated.
Andrew Thorne
Lead Software Engineer
PeopleSoft Technical Architecture
Enterprise Rent-A-Car
Lead Software Engineer
PeopleSoft Technical Architecture
Enterprise Rent-A-Car
The deadlock daemon is not needed. Back in the day tech support used to tell customers take it out of the services startup script because it would go bonkers and chew up a cpu. You can kill it the process, and remove it from the startup script.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Its main purpose is to clear out locks where the underlying process has died. Given the volume of posters looking for ways to release locks indicates the daemon is not too quick on the draw for finding these ophaned locks and releasing them. Since you can do it yourself much faster, why wait or use the daemon? It doesn't run your jobs, it doesn't work with the GUI clients, so what is it really doing for you? Wasting a cpu is about it.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
I think that may be due more to the fact that it defaults to being off nowadays and most (new) people don't seem to know about it.kcbland wrote:Given the volume of posters looking for ways to release locks indicates the daemon is not too quick on the draw for finding these ophaned locks and releasing them.
That being said, if it's not really doing all that much, I won't feel all that bad about shutting it down the next time it gets out of hand.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers