Locked job not released

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sgiang
Participant
Posts: 4
Joined: Wed Sep 07, 2005 8:33 pm

Locked job not released

Post by sgiang »

Hi, guys

I have set the parameter start=1 in dsdlockd.config. All else remains as default. The daemon is running. It should wakeup every 15 minutes to cleanup defunct processes, right ? However, my job is still locked after 2.5 hrs. Does it mean that the the daemon is not working due to whatever reason ? Can someone explain this ?

Thanks.

Regards
Giang
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

You can check the daemon log file to see what it has been doing, but it should clear up locks for objects that it thinks are incorrect. If a lock is present because a process has aborted or had a "kill -9" done to it then the deadlock daemon will clean that up. If you have a lock held on a job by some active process then the deadlock daemon will take no action since it can't detect the difference between a valid user process and one that should no longer be running.

How did you locked job error come about? Could the locking process still be active?
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

If it is locked you should be able to see at cleanup resourse. And you can find the list of items holding the process by selecting the process id and Click on show by process.
If it as any valid job or record holded, you can close the job which holds the record or release it.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
sgiang
Participant
Posts: 4
Joined: Wed Sep 07, 2005 8:33 pm

Post by sgiang »

Thanks, ArndW for the explanation.

I opened a job in Designer and the session was left idle, so it timed out, thus locking the job. So the configuration changes made to dsdlockd.config did not work in this case. Looks like I will need to unlock it in Director.

This leads me to another question, How can I set it such that my client session will not time-out ? I can't seem to be able to find it in Administrator.

Regards
Giang





ArndW wrote:You can check the daemon log file to see what it has been doing, but it should clear up locks for objects that it thinks are incorrect. If a lock is present because a process has aborted or had a "kill -9" done to it then the deadlock daemon will clean that up. If you have a lock held on a job by some active process then the deadlock daemon will take no action since it can't detect the difference between a valid user process and one that should no longer be running.

How did you locked job error come about? Could the locking process still be active?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

sgiang wrote:How can I set it such that my client session will not time-out ? I can't seem to be able to find it in Administrator.

It's there, right on the front from what I recall, but you need to be 'dsadm' to change it. Next to the timeout value is a checkbox to 'Never timeout'.
-craig

"You can never have too many knives" -- Logan Nine Fingers
sgiang
Participant
Posts: 4
Joined: Wed Sep 07, 2005 8:33 pm

Post by sgiang »

Thanks, Craig. I got it now. I must be blind before.

Regards
Giang



chulett wrote:
sgiang wrote:How can I set it such that my client session will not time-out ? I can't seem to be able to find it in Administrator.

It's there, right on the front from what I recall, but you need to be 'dsadm' to change it. Next to the timeout value is a checkbox to 'Never timeout'.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

sgiang wrote:...I opened a job in Designer and the session was left idle, so it timed out, thus locking the job. So the configuration changes made to dsdlockd.config did not work in this case...


That is exactly the kind of lock that the deadlock daemon will take care of.
Post Reply