IDS Forum

RE: RFE request for session details during vir....

Posted By: Alexandre Marini
Date: Tuesday, 2 December 2014, at 11:04 a.m.

In Response To: RE: RFE request for session details during vir.... (Paul Watson)

Yes, Paul, but even if it would, that would generate an AF file, together with a shm dump, and I could not risk filling up any filesystem, since I don't know how many times it would happen, it is a risk I don't want to deal with. We would rather let shm dumps available only in case, for support critical issues.

But I appreciate your best intentions to help, anyway.
Thanks

Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10

IBM Information Management Informix Technical Professional

IBM Certified Developer - Informix Genero
BRIUG website administrator
Informix independent consultant

> To: ids@iiug.org
> From: paul@oninit.com
> Subject: RE: RFE request for session details during vir.... [34255]
> Date: Tue, 2 Dec 2014 10:32:35 -0500
>
> You could run an onmode -I 22/28 but I don't think I would run that in
> production :-) But again only helping when it is too late
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Alexandre Marini
> > Sent: Tuesday, December 02, 2014 9:27 AM
> > To: ids@iiug.org
> > Subject: RE: RFE request for session details during vir.... [34254]
> >
> > Yes, Paul, indeed. The issue is to catch things as soon as they happen.
> > Any monitor tool (including an online.log parser), would not do this
> trick.
> >
> > Let's see if Fernando or Jacques can find something that could help us on
> > this....
> > Thanks for the tips.
> > Regards.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Certified Developer - Informix Genero
> > BRIUG website administrator
> > Informix independent consultant
> >
> > > To: ids@iiug.org
> > > From: paul@oninit.com
> > > Subject: RE: RFE request for session details during vir.... [34252]
> > > Date: Tue, 2 Dec 2014 09:49:47 -0500
> > >
> > > We use Nagios to track when a number segment is added and spawn a
> > script to
> > > capture stuff. It's not ideal as Nagios runs every xx mins so it doesn't
> > > capture the 'all hell breaking loose' memory requrements but ...
> > >
> > > Cheers
> > > Paul
> > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > > Fernando Nunes
> > > > Sent: Monday, December 01, 2014 12:40 PM
> > > > To: ids@iiug.org
> > > > Subject: Re: RFE request for session details during vir.... [34242]
> > > >
> > > > I'm not sure if I completely understand the request. But apparently
> you
> > > > want the SID of the session that caused the new memory segment to be
> > > > added.
> > > > But this does not necessarily means that that session is the one
> > consuming
> > > > more memory. Specially in an high activity system. Let's assume SID= y
> is
> > > > doing something nasty and it consumes a lot of memory. At time T0 it
> > > > allocates a large chunk of memory for a sort or whatever. Between T0
> > and
> > > T1
> > > > a lot of other sessions allocate small ammounts of blocks. At T1 a
> > > > different session (SID=y) needs some memory that isn't available, and
> > that
> > > > triggers a new segment allocation. You'd get SID=y and not SID=x in
> the
> > > > messge.
> > > >
> > > > Beside that, systems can now allocate memory in pro-active mode
> > (meaning
> > > > no
> > > > SID is associated with it).
> > > >
> > > > What I think you need is an expedite way of showing which sessions are
> > > > consuming more memory at a specific time (onstat -u is limmited for
> that,
> > > > and I do agree some other option would be interesting). Once you have
> a
> > > > way
> > > > to do that (and we can create a script to do what you mention) you
> just
> > > > have to call it in the ALARMPROGRAM script when the event is the one
> > > > you're
> > > > looking for...
> > > >
> > > > Regards
> > > >
> > > > On Mon, Dec 1, 2014 at 5:32 PM, Alexandre Marini
> > <alexandre@briug.org>
> > > > wrote:
> > > >
> > > > > Hello.
> > > > > I think this might be a very useful RFE, in order to help us to
> identify
> > > > > abnormal memory session usage, in OLTP systems of high ammount of
> > > > > concurrent
> > > > > sessions (ad-hoc applications).
> > > > >
> > > > > If anyone like, please vote it...
> > > > >
> > > >
> > https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&C
> > > > R_ID=62730
> > > > >
> > > > > Regards.
> > > > >
> > > > > Alexandre Marini
> > > > > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> > > > >
> > > > > IBM Information Management Informix Technical Professional
> > > > >
> > > > > IBM Certified Developer - Informix Genero
> > > > > BRIUG website administrator
> > > > > Informix independent consultant
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > > --
> > > > Fernando Nunes
> > > > Portugal
> > > >
> > > > http://informix-technology.blogspot.com
> > > > My email works... but I don't check it frequently...
> > > >
> > > > --001a113fd708c081b205092beeb0
> > > >
> > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> > **********************************************************
> > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• RFE request for session details during virtual shm
  Alexandre Marini -- Monday, 1 December 2014, at 12:32 p.m.
  • Re: RFE request for session details during virtual
    Fernando Nunes -- Monday, 1 December 2014, at 1:40 p.m.
    • Re: RFE request for session details during vir....
      Art Kagel -- Monday, 1 December 2014, at 2:53 p.m.
      • Re: RFE request for session details during vir....
        Fernando Nunes -- Monday, 1 December 2014, at 5:05 p.m.
        • RE: RFE request for session details during vir....
          Alexandre Marini -- Tuesday, 2 December 2014, at 5:53 a.m.
    • Re: RFE request for session details during virtual
      JACQUES RENAUT -- Tuesday, 2 December 2014, at 9:40 a.m.
      • RE: RFE request for session details during virtual
        Alexandre Marini -- Tuesday, 2 December 2014, at 10:14 a.m.
    • RE: RFE request for session details during vir....
      Paul Watson -- Tuesday, 2 December 2014, at 9:49 a.m.
      • RE: RFE request for session details during vir....
        Alexandre Marini -- Tuesday, 2 December 2014, at 10:26 a.m.
        • RE: RFE request for session details during vir....
          Paul Watson -- Tuesday, 2 December 2014, at 10:32 a.m.
          • RE: RFE request for session details during vir....
            Alexandre Marini -- Tuesday, 2 December 2014, at 11:04 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.