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: Efficiency of the Informix Virtual Processors

Posted By: Fernando Nunes
Date: Monday, 17 September 2012, at 11:40 a.m.

In Response To: Re: Efficiency of the Informix Virtual Processors (KERNOAL STEPHENS)

Be careful when using 11.50.xC4 and 111.50.xC5. If you run onstat -z it
does not clear some counters that are used to calculate the efficiency.
it should be resolved in FC6.
Regards

On Mon, Sep 17, 2012 at 2:36 PM, KERNOAL STEPHENS <informixdba@gmail.com>wrote:

> Mr. Miller, I agree please please give us more information.
> Here is my onstat -g glo output
> IDS 11.50.FC4 AIX 6.1 100GB Memory
> This is a dedicated database server with two RSS servers.
>
> lparstat -i
> Entitled Capacity : 6.00
> Partition Group-ID : 32771
> Shared Pool ID : 0
> Online Virtual CPUs : 16
> Maximum Virtual CPUs : 40
> Minimum Virtual CPUs : 12
> Online Memory : 102400 MB
> Maximum Memory : 391168 MB
> Minimum Memory : 51200 MB
> Variable Capacity Weight : 128
> Minimum Capacity : 3.00
> Maximum Capacity : 24.00
> Capacity Increment : 0.01
> Maximum Physical CPUs in system : 24
> Active Physical CPUs in system : 24
> Active CPUs in Pool : 24
> Shared Physical CPUs in system : 24
> Maximum Capacity of Pool : 2400
> Entitled Capacity of Pool : 1400
> Unallocated Capacity : 0.00
> Physical CPU Percentage : 37.50%
> Unallocated Weight : 0
> Memory Mode : Dedicated
>
> onstat -g glo # onstat -z ran 233 hours ago.
> Individual virtual processors:
> vp pid class usercpu syscpu total Thread Eff
> 1 9306260 cpu 61921.09 5929.83 67850.92 1086541.07 6%
> 2 9371712 adm 69.65 86.84 156.49 0.00 0%
> 3 9764882 cpu 58075.15 5579.70 63654.85 1000264.80 6%
> 4 9240686 cpu 42165.60 3941.65 46107.25 786594.57 5%
> 5 10223730 cpu 32178.53 2576.11 34754.64 575069.70 6%
> 6 9896030 cpu 22642.97 1781.54 24424.51 399043.91 6%
> 7 9699452 cpu 15832.24 1192.76 17025.00 271041.72 6%
> 8 10289268 cpu 10792.72 793.54 11586.26 182091.72 6%
> 9 7536650 cpu 7345.01 516.29 7861.30 119821.27 6%
> 10 11403318 cpu 4592.01 338.14 4930.15 81069.26 6%
> 11 9961648 cpu 2981.45 223.68 3205.13 52533.06 6%
> 12 9044046 cpu 2003.38 152.03 2155.41 36348.34 5%
> 13 10354854 cpu 1342.80 105.70 1448.50 28362.36 5%
> 14 8060994 cpu 823.10 75.60 898.70 19885.19 4%
> 15 10879094 cpu 596.76 57.27 654.03 15916.24 4%
> 16 7995558 cpu 499.97 42.31 542.28 13790.68 3%
> 17 11206748 cpu 411.83 33.13 444.96 12228.72 3%
> 18 10420348 cpu 295.72 25.56 321.28 9729.11 3%
> 19 11337872 cpu 213.88 20.33 234.21 5855.20 4%
> 20 852032 cpu 145.93 16.02 161.95 5567.20 2%
> 21 8978514 cpu 153.39 13.26 166.65 4255.98 3%
> 22 9568448 cpu 97.95 11.29 109.24 5871.01 1%
> 23 8585238 cpu 79.82 9.60 89.42 2464.62 3%
> 24 8388658 cpu 90.23 8.52 98.75 2402.26 4%
> 25 9175092 cpu 94.36 9.54 103.90 2808.00 3%
>
> ps -ef | grep oninit # from august 7
> informix 852032 9371712 0 Aug 07 - 26:45 oninit -jvy
> informix 7536650 9371712 0 Aug 07 - 543:13 oninit -jvy
> informix 7995558 9371712 0 Aug 07 - 59:59 oninit -jvy
> informix 8060994 9371712 0 Aug 07 - 80:32 oninit -jvy
> informix 8192134 9371712 0 Aug 07 - 107:05 oninit -jvy
> informix 8257648 9371712 0 Aug 07 - 0:16 oninit -jvy
> informix 8388658 9371712 0 Aug 07 - 10:25 oninit -jvy
> informix 8585238 9371712 0 Aug 07 - 8:11 oninit -jvy
> informix 8978514 9371712 0 Aug 07 - 18:33 oninit -jvy
> informix 9044046 9371712 0 Aug 07 - 161:11 oninit -jvy
> informix 9175092 9371712 0 Aug 07 - 16:23 oninit -jvy
> informix 9240686 9371712 29 Aug 07 - 3382:12 oninit -jvy
> informix 9306260 1 62 Aug 07 - 4718:18 oninit -jvy
> informix 9371712 9306260 0 Aug 07 - 10:50 oninit -jvy
> informix 9568448 9371712 0 Aug 07 - 40:03 oninit -jvy
> informix 9633854 9371712 0 Aug 07 - 167:56 oninit -jvy
> informix 9699452 9371712 55 Aug 07 - 1208:47 oninit -jvy
> informix 9764882 9371712 41 Aug 07 - 4337:44 oninit -jvy
> informix 9896030 9371712 12 Aug 07 - 1768:03 oninit -jvy
> informix 9961648 9371712 0 Aug 07 - 235:32 oninit -jvy
> informix 10223730 9371712 29 Aug 07 - 2495:12 oninit -jvy
> informix 10289268 9371712 24 Aug 07 - 818:13 oninit -jvy
> informix 10354854 9371712 0 Aug 07 - 132:58 oninit -jvy
> informix 10420348 9371712 0 Aug 07 - 46:46 oninit -jvy
> informix 10682462 9371712 1 Aug 07 - 155:46 oninit -jvy
> informix 10813532 9371712 0 Aug 07 - 0:16 oninit -jvy
> informix 10879094 9371712 0 Aug 07 - 64:18 oninit -jvy
> informix 11206748 9371712 0 Aug 07 - 57:43 oninit -jvy
> informix 11337872 9371712 0 Aug 07 - 20:18 oninit -jvy
> informix 11403318 9371712 0 Aug 07 - 379:17 oninit -jvy
> informix 11534448 9371712 0 Aug 07 - 163:04 oninit -jvy
> informix 11665516 9371712 0 Aug 07 - 0:39 oninit -jvy
> informix 11731052 9371712 0 Aug 07 - 170:09 oninit -jvy
> informix 11796590 9371712 0 Aug 07 - 162:29 oninit -jvy
> informix 11862128 9371712 2 Aug 07 - 160:17 oninit -jvy
> informix 11927668 9371712 0 Aug 07 - 0:20 oninit -jvy
> informix 11993210 9371712 1 Aug 07 - 176:20 oninit -jvy
> informix 12058746 9371712 0 Aug 07 - 0:20 oninit -jvy
> informix 12189816 9371712 0 Aug 07 - 158:55 oninit -jvy
> informix 12320888 9371712 0 Aug 07 - 0:20 oninit -jvy
>
>
>
> *******************************************************************************
> 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...

--20cf302ef94aef1daf04c9e79620

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.