Informix process reads a lot of pages
A user on IDS 7.31.UD8 (Linux, HDR primary) saw one Informix process reading large numbers of pages even though nobody appeared to be using the server, and asked how to identify it. Suggestions were to use 'onstat -g ses' and 'onstat -g ses <session id>' (substituting a real session number) to see what the session was executing; Art Kagel also suggested bouncing the instance (shutting the HDR secondary first if DRAUTO is non-zero) and comparing two 'onstat -u' snapshots, since sessions with big changes in the right-most read/write columns are the culprits. The user reported the busy session didn't appear in 'onstat -g ses' output, and no resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello, I have a problem with Informix 7.31.UD8 on Linux. One of the Informix process reads a lot of pages. Can I see what does do this process? Why this process reads pages, when nobody use IDS?
You could start with an onstat -g ses <sessionid> to see what it is actually
executing.
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MATEUSZ P
Sent: Tuesday, November 29, 2011 7:15 AM
To: ids@iiug.org
Subject: Informix process reads a lot of pages [25493]
Hello,
I have a problem with Informix 7.31.UD8 on Linux.
One of the Informix process reads a lot of pages.
Can I see what does do this process?
Why this process reads pages, when nobody use IDS?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
onstat -g ses and onstat -g ses <session id> to see what sessions are doing.
You REALLY should upgrade!
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
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, Nov 29, 2011 at 7:15 AM, MATEUSZ P <mausz@wp.pl> wrote:
> Hello,
>
> I have a problem with Informix 7.31.UD8 on Linux.
> One of the Informix process reads a lot of pages.
> Can I see what does do this process?
> Why this process reads pages, when nobody use IDS?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3ba4d35a79a604b2df4c79
I try onstat -g ses and onstat -g ses <session id> but results was:
IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line (Prim) -- Up 8 days
I try onstat -g ses and onstat -g ses <session id> but results was:
IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line (Prim) -- Up 8 days
So, running "onstat -g ses" shows no output except the report header line?
Something is not right. If this is true, I would try bouncing the
instance. I see that this is the primary of an HDR pair - if the secondary
is configured with DRAUTO set to anything but zero shutdown the secondary
first then bounce the primary and finally restart the secondary. Otherwise
you may have problems with the secondary taking over as the primary when
you shut the primary down.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
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, Nov 29, 2011 at 8:16 AM, MATEUSZ P <mausz@wp.pl> wrote:
> I try onstat -g ses and onstat -g ses <session id> but results was:
> IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line (Prim) -- Up 8 days>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae934065513703004b2dfd0d0
>So, running "onstat -g ses" shows no output except the report header line?
"onstat -g ses <session id>" shows the report header.
"onstat -g ses" shows some sessions, but not this session which reads a lot of
pages
Try substituting the session id numbers from the output of onstat -g ses for
the <session id>. IE:
onstat -g ses 1244456, not onstat -g ses <session id>
--EEM
>-----Original Message-----
>From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>MATEUSZ P
>Sent: Tuesday, November 29, 2011 8:46 AM
>To: ids@iiug.org
>Subject: Re: Informix process reads a lot of pages [25500]
>
>>So, running "onstat -g ses" shows no output except the report header
>line?
>"onstat -g ses <session id>" shows the report header.
>"onstat -g ses" shows some sessions, but not this session which reads a
>lot of pages
>
>
>************************************************************************
>*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
Run onstat -u to file. Repeat to a different file an diff the files.
Sessions with large changes in the right most two columns are the culprits.
Art
On Nov 29, 2011 7:46 AM, "MATEUSZ P" <mausz@wp.pl> wrote:
> >So, running "onstat -g ses" shows no output except the report header line?
> "onstat -g ses <session id>" shows the report header.
> "onstat -g ses" shows some sessions, but not this session which reads a
> lot of
> pages
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec52e601fbdab1a04b2e75273