Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

RE: Cannot kill session (onmode -z doesn't work)

Posted By: Dirk Cornelis Moolman [ MTN - Innovation Centre ]
Date: Tuesday, 5 July 2011, at 9:44 a.m.

In Response To: Re: Cannot kill session (onmode -z doesn't work) (Fernando Nunes)

Thanks Fernando.

> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Fernando Nunes
> Sent: Wednesday, 29 June 2011 07:30 PM
> To: ids@iiug.org
> Subject: Re: Cannot kill session (onmode -z doesn't work) [24184]
>
> As I mentioned, even a few hours would be more than enough.
> You definitively have a very serious issue... those two java sessions
> are
> consuming more than 1.5GB of RAM.
> I cannot explain why onstat -g stm sid doesn't show anything...
> Eventually
> they don't have nothing prepared, but I hardly believe that. You can do
> an
> onstat -g ses to check which memory pools are consuming more memory
> within
> the instance.
>
> In any case, a PMR may be the easiest way to go... Possibly it's only
> something in the application, but in that case tech support can help
> you
> find what. On the other hand if there is a memory leak in the server
> you'd
> really need tech support.
>
> Regards.

> On Wed, Jun 29, 2011 at 1:01 PM, Dirk Cornel....
> <moolma_dc@mtn.co.za>wrote:
>
> > We are now running into the same problem again. I tried the "onstat -
> g stm
> > SID", but it comes back with nothing.
> >
> > mtnx87.mtn.co.za:/ # onstat -g stm 24416
> >
> > IBM Informix Dynamic Server Version 10.00.FC8XF -- On-Line -- Up 3
> days
> > 12:36:09 -- 157286176 Kbytes
> >
> > session 24416
> > ---------------------------------------------------------------
> > sdblock heapsz statement ('*' = Open cursor)
> >
> > I ran it for the session taking the most memory again -
> >
> > mtnx87.mtn.co.za:/ # onstat -g ses | sort -nr -k 8 | more
> > 24416 compans - -1 mtnepp17 1 1104437248 821853816 off
> > 1918648 compans - -1 mtnepp17 1 627732480 627723024 off
> > 213352 root - 393443 mtnepp16 1 12611584 12223256 off
> > 2010236 root - 103699 mtnepp16 1 11874304 11474120 off
> > 1934587 root - 310760 mtnepp16 1 10776576 10772344 off
> > 1900065 root - 17593 mtnepp16 1 10842112 10591824 off
> > 1939737 root - 49782 mtnepp16 1 10203136 9949496 off
> > 1912556 root - 29692 mtnepp16 1 9408512 9191848 off
> > 1949170 root - 56065 mtnepp16 1 9183232 8739384 off
> > 1911515 root - 25919 mtnepp16 1 9027584 8639688 off
> > 1920278 root - 34257 mtnepp16 1 8986624 8380720 off
> > 697526 root - 95294 mtnepp16 1 9277440 8216904 off
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of
> > > Fernando Nunes
> > > Sent: Saturday, 25 June 2011 03:24 PM
> > > To: ids@iiug.org
> > > Subject: Re: Cannot kill session (onmode -z doesn't work) [24149]
> > >
> > > Although 5H is way too much, can you check if the memory decreased
> > > since you
> > > run onmode -z?
> > > In a situation like this even when it works it takes some time
> (minutes
> > > not
> > > hours). I've seen 15m with more or less the same amount of memory
> in a
> > > server that was not swapping.
> > >
> > > In any case, before you kill the session, run an onstat -g stm SID
> > > This will show you the prepared statements for the session. Most
> > > probably
> > > your application is repeating prepares for one or more statements.
> > > Most if not all the situations I've seen (I'd say 80%) are from
> Java
> > > programs.
> > > Not that Java is inherently bad, but apparently it becomes easier
> to
> > > make
> > > the above mistake.
> > >
> > > By the way, the session does have a PID. It's "-1" which signals
> it's a
> > > java
> > > program (in pure Java code there is not (or there was no...) way to
> get
> > > the
> > > process id. That's why it shows -1
> > >
> > > In short: I may not be able to help you to kill that session, but
> it's
> > > at
> > > least as important to see why it happened. If it's the prepare
> problem
> > > above
> > > than the application code must be changed.
> > >
> > > Regards.
> >
> > > On Sat, Jun 25, 2011 at 1:59 PM, Dirk Cornel....
> > > <moolma_dc@mtn.co.za>wrote:
> > >
> > > > IDS 10
> > > > AIX 5
> > > >
> > > > Our server started swapping seriously, and I looked at the
> sessions
> > > using
> > > > the
> > > > most memory:
> > > >
> > > > mtnx87.mtn.co.za:/ # onstat -g ses | sort -nr -k 8 | more
> > > > 14247 compans - -1 mtnepp17 1 1545867264 1256744912 off
> > > > 990910 root - 29740 mtnepp16 1 9289728 8973456 off
> > > > 1010090 root - 38588 mtnepp16 1 8753152 8567712 off
> > > > 409418 root - 227618 mtnepp16 1 9232384 8371432 off
> > > > 2062 root - 1982 mtnepp16 1 8732672 8218912 off
> > > > 1010418 root - 47034 mtnepp16 1 8314880 7973072 off
> > > > 524172 root - 307888 mtnepp16 1 8572928 7972744 off
> > > > 1011113 root - 57346 mtnepp16 1 8441856 7966376 off
> > > >
> > > > The top one, does not have a corresponding PID. It seems like a
> > > runaway
> > > > process that died, or was killed, and the SID stayed behind.
> > > >
> > > > I tried killing it (onmode -z), but for the last 5 hours it just
> > > won't kill
> > > > .... and I can't shut down the database at this stage (I don't
> have a
> > > > downtime
> > > > window now).
> > > >
> > > > Any ideas ?
> > > >
> > > > Dirk
> > > >
> > > > ________________________________
> > > > NOTE: This e-mail message is subject to the MTN Group disclaimer
> see
> > > > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> > > >
> > > >
> > > >
> > > >
> > >
> ***********************************************************************
> > > ********
> > > > 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...
> > >
> > > --0016e6469ad2c5553904a6893aa3
> > >
> > >
> > >
> ***********************************************************************
> > > ********
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > NOTE: This e-mail message is subject to the MTN Group disclaimer see
> > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> >
> >
> >
> >
> ***********************************************************************
> ********
> > 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...
>
> --001636c92c1eee590104a6dd2147
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.

NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.