Page 1 of 1

Cleanup resource error

Posted: Fri Jun 05, 2009 1:50 pm
by mandyli
Hi


I would know about my job process id. when I enter into Datastage director and do the cleanup resource and click showall or show by job then I got following error

Error : Can't find any process numbers for stages in Job myjobs


But If I execute the following command in DS admin tool I am getting my job name with process id.

list.readu


Thanks for your suggestion.

Thanks
Man

Posted: Fri Jun 05, 2009 3:08 pm
by samsuf2002
Even I found that in 8.0 that when any jobs gets locked and if we try to clean up the resources it doesn't show the PID because it already unlocks it. If you wait for a while and open the job in designer, it will open fine.

Not sure if this is just an assumption.

Posted: Fri Jun 05, 2009 3:44 pm
by ray.wurlod
This IS an assumption, and suggests that you have the DataStage deadlock daemon running.

When a job has no processes, this typically means that the job process has been killed.

However, the job process (now defunct) still holds locks in the lock table, which is what you view with list_readu. You have to go through the appropriate process for clearing locks held by defunct processes.

DataStage deadlock daemon periodically clears locks held by defunct processes in the local repository.

Posted: Fri Jun 05, 2009 8:12 pm
by chulett
In other words, there is no error. Your processes no longer exist, which is why Cleanup Resources says what it does, but the internal locks associated with them still are there, hence the list.readu output.