Re: Slow Process

>Informix 7.30 >Hp 9000 unix >4 Proc. >1 gig RAM >2 db instances of 14 gig each (approx.) >Application: Elite Legal Billing System >Process: Proforma Generation > >We recently upgraded from 5.10 to 7.30. Everything is running >smoothly with the exception of "proforma" generation (reports >of all unbilled time and costs). This process queries the biggest >tables in the db. > >The usual procedure is for us to queue up 8-10 of these processes >for our different office locations. Before the upgrade, 90% of >these would be completed within 9 hours. After the upgrade the >bigger offices took an incredible amount of time to complete and >some of them never did. Symptom: Process starts out generating >very quickly (a count is displayed), but as the process continues it >gets slower and slower (smaller offices do finish in a timely >manner). We ended up stopping the process, then starting it again >from where it left off. The same symptom would be exhibited. ******************************* Have you run UPDATE STATISTICS? ******************************* >At first we thought this might be caused by swapping (2 instances >are eating up most of our RAM), but even after rebooting, running >only one instance, and only running one process, the same symptom >has occurred. > >We've played around a bit with PDQ, but that has helped very little. Don't! It can lead to even more problems (although you have to actively enable it) >The same symptom is exhibited on both instances (the 2nd instance >is a "history" db as of 12/1998). > >We have also performed a tbcheck -cI on the history db without any >problems. > >We will be adding another gig of RAM and a new version of the >application (2.5d) and I'm hoping against hope that this may >help. > >Any other suggestions would be appreciated. Also, if anyone else >running Elite has had this problem, I'd love to know how it was >resolved. > >Oh, on an unrelated (maybe) subject: Are oninit processes >supposed to build up a lot of time (1453 seconds over a couple days)? >That was something that sort of jumped out at me, but the Informix >guy at Elite said it was ok. He's right. Those oninit processes are doing all the work of your old sqlturbo processes, that's why they chew up so much CPU time. A copy of your onconfig file might be useful, along with how many users you're running. But try the UPDATE STATISTICS first. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com