CE 10 - Jobserverchild still running on DB2 connection

[bballjunky]

No jobs show as running, yet there are currently 3 jobserverchild.exe process running in task manager using up CPU. DB@ admin sees the threads, but they are not running anything, but still have locks on tables. Why are these processes not closing when the report is finished?

 

[SomeHelp]

This usually happens because the report was stopped prematurly before it completes to success. I have seen this often on big reports that have been running for one or two hours and then the user stops or deletes the job in the CMC. Sometimes these get cleaned up by CE, but many times they do not. We have a perl script utility we wrote which compares number of jobs actually running in CE and the number of jobserverchild process that are running on the system. The script then sends out a page saying the jobserverchilds are out of sync and then we must terminal service into the CE server and kill the orphaned jobserverchild processes. I would recommend appling the latest service pack for CE10, which is SP2 and this may clear up some of these orphaned processes.