Re: Informix hogging CPU

In <608mmj$ao9$1@malgudi.oar.net> william@carsinfo.com (William Harris) writes: > >In article <01bcc7c5$2c0d86e0$14203fce@mmatt>, mmatt@halcyon.com says... >>10.10. When Informix gets hit with an SQL statement doing a few joins an a >>35,000 record database, the system just crawls while the statement >>executes (takes about 5 minutes). No one can login and if you are logged >>in, you get a response to hitting ENTER about 40 seconds after hitting it. > >Informix 7.14 under single-processor HPUX systems had/has a major problem >where no matter how you set the engine up, the oninit process priority would >age and the database would get slower and slower and slower. Informix has >been working on it; I've seen behavior such as you say, but when I saw it, I >don't think it was related to a specific query; it seemed to be more related >to how long the engine had been up and how much the databases had been used in >that period. > >HP does has a patch that can put the engine into a separate process group and >let you manually set the priority. You might want to contact them and >Informix for the latest word. Try switching NOAGE off and seeing if that makes a difference. Errol