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

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: Wednesday, 29 June 2011, at 8:01 a.m.

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

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

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.