RE: System Freezes

No, we don't have many stored procedures. If we are using any, they are nothing that we don't use elsewhere throughout the system. We do have some pretty complex SQL. I've looked with set explain and I'm going to try to improve it, but I don't have anything that takes more than a second or two to run with dbaccess. Of course, I do have much more web traffic firing this SQL than I can generate with dbaccess. As far as updstats goes, it looks like the scheduler is running "aus_refresh_stats" with these parameters: Parameter Name: AUD_PDQ Value: 10 ValueType: Numeric From: Art Kagel [mailto:art.kagel@gmail.com] Sent: Tuesday, January 11, 2011 2:46 PM To: Rubinstein, James Cc: informix-list@iiug.org Subject: Re: System Freezes Does the new application use many stored procedures? Is it possible that the stored procedures were recompiled (update statistics for procedure/function ....) with PDQPRIORITY set to something other than zero? Just one idea? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jan 11, 2011 at 4:29 PM, Rubinstein, James <JRUBIN@midwestern.edu> wrote: I'm running IDS 11.50.FC6 on HPUX 11.31. We recently rolled out an internally developed web-based system (Apache perl/mod_perl) and immediately started noticing that our HPUX system becomes completely unresponsive, for 20-30 seconds at a time, many times throughout the day. My first thought was network problems, but we have pretty much ruled this out since I can connect to a twin HPUX server which seems fine during the outages. During these system freezes, any connections to the database fail and the system is completely unresponsive to the point that I cannot even type any commands at the shell. I have seen this behavior in the past when the oninit processes use a lot of CPU resources, but it is usually pretty easy to track these down to some bad SQL/report writing. In this case, I'm trying to figure out what may be causing the system freezes. I have top and the dbtop utility from IIUG, but those don't refresh during or freezes. I am also unable to type any onstat commands until the system comes back. By that time, everything looks pretty normal with low load averages and our oninit processes at normal levels. I'm looking at the various system reports in OAT, but don't see anything that jumps out as the culprit. I'd appreciate any troubleshooting ideas. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list