Re: System Freezes
Rats. Itanium doesn't have the problem I was thinking of.
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 5:54 PM, Rubinstein, James <JRUBIN@midwestern.edu>wrote:
> Itanium – rx6600 server.
>
>
>
> *From:* Art Kagel [mailto:art.kagel@gmail.com]
> *Sent:* Tuesday, January 11, 2011 3:50 PM
> *To:* Rubinstein, James
> *Cc:* informix-list@iiug.org
> *Subject:* Re: System Freezes
>
>
>
> Wait, HPUX? Is this a PA-RISC system or Itanium? If PA-RISC, how many
> shared memory segments (specifically the Resident and Virtual segments) does
> the engine have (onstat -g seg)? What do you have RESIDENT set to? If you
> have more than one virtual segment you could be seeing the PA-RISC processor
> design flaw problem. Increase SHMVIRTSIZE to include the sizes of any
> virtual segments besides the first (or all of the ones you see if you have
> RESIDENT set to -1 - since then the first virtual segment should have been
> consolidated into the resident segment) into SHMVIRTSIZE and bounce the
> instance.
>
> 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 5:04 PM, Art Kagel <art.kagel@gmail.com> wrote:
>
> That's OK, the AUS refresh knows enough to compile any SPL routines with
> PDQPRIORITY 0, so red herring. This is going to be a tough one to crack.
> Any indications of long checkpoints with blocked sessions in the message
> log?
>
> 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:54 PM, Rubinstein, James <JRUBIN@midwestern.edu>
> wrote:
>
> 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
>
>
>
>
>
>
>