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: Cesar Inacio Martins
Date: Tuesday, 18 September 2012, at 11:48 a.m.

In Response To: Efficiency of the Informix Virtual Processors (VIKAS HIVARKAR)

I agree too , more information about the "cautions" of this efficiency
versus OS (and hardware processor) will help a lot...

I'm have "trouble" with this too , running ifx 11.50 FC9X6 / AIX 6.1
Running over P7 with smt4 active (I'm not able to change this...)

Before I have the CPU VPs = 50% Virtual CPUs configured at LPAR... and
the efficency stay in +- 58%
After read the article , I decided try get better efficiency , without
much information about this, my guess was I have to much CPUs VPs .
So than I drop 50% of CPU VPs (to keep 1 to 1 , VPs to CPU Core) , and
have no effect over this efficiency %. (drop CPUs executed with onmode -p )
Not sure if my case the SMT4 can influence over this % .
(and as murphy law, after this change, coincidentally or not , start
occur a delay at the synchronization with the secondary RSS we have...
I already back the original configuration, with "onmode -p", but the
delay just keep occurring........ )

Individual virtual processors:
vp pid class usercpu syscpu total Thread Eff
1 10551656 cpu 132706.76 8656.04 141362.80 248690.25 56%
2 13762800 adm 28.76 18.99 47.75 0.00 0%
3 4063256 cpu 120849.68 8091.60 128941.28 226326.39 56%
4 6094914 cpu 154062.98 5091.50 159154.48 272209.02 58%
5 10092874 cpu 140383.18 4337.14 144720.32 247128.23 58%
6 8847682 cpu 125294.04 3641.25 128935.29 220377.38 58%
7 4915308 cpu 108976.18 2967.08 111943.26 190530.60 58%
8 3932614 cpu 94901.89 2357.15 97259.04 165851.22 58%
9 3801578 cpu 75074.01 2000.38 77074.39 133304.05 57%
10 6160450 cpu 60000.93 1619.67 61620.60 106861.15 57%
11 6225988 cpu 48347.76 1105.54 49453.30 85851.22 57%
12 4063612 cpu 38805.02 802.80 39607.82 69669.11 56%
13 6291526 cpu 36468.80 769.14 37237.94 65888.62 56%
14 6357064 cpu 27033.82 553.98 27587.80 48921.86 56%
15 4194636 cpu 22312.50 476.64 22789.14 40905.80 55%
16 4260178 cpu 19096.00 342.96 19438.96 35710.58 54%
17 4391256 cpu 20980.78 315.93 21296.71 39054.33 54%

On 17/9/2012 04:02, VIKAS HIVARKAR wrote:
> Dear All,
>
> IDS 11.50.FC8W2 on Hp-UX 11.23 (12 core - 55 GB mem to informix)
> No other instance running on this machine.
>
> I was reading a post by john on http://www.jfmiii.com/informix/?p=194
>
> It say that if the efficiency drops below 80% (onstat -g glo output) then
> there seems to be a problem,
>
> On my server this is way below 80%
>
> Individual virtual processors:
> vp pid class usercpu syscpu total Thread Eff
> 1 25998 cpu 596999.56 59735.98 656735.54 1386304.24 47%
> 2 26022 adm 565.72 242.50 808.22 0.00 0%
> 3 26023 cpu 760472.90 67782.91 828255.81 1482334.68 55%
> 4 26024 cpu 753012.02 66183.48 819195.50 1460697.74 56%
> 5 26025 cpu 728624.77 64313.88 792938.65 1414304.29 56%
> 6 26026 cpu 700316.87 61741.94 762058.81 1368809.35 55%
> 7 26027 cpu 681275.04 59123.57 740398.61 1326279.11 55%
> 8 26028 cpu 658406.09 56558.96 714965.05 1281118.10 55%
> 9 26029 cpu 640571.90 54235.48 694807.38 1246049.98 55%
> 10 26034 cpu 623314.34 52530.00 675844.34 1210579.85 55%
> 11 26035 cpu 609543.16 51168.91 660712.07 1180016.85 55%
> 12 26036 cpu 596393.14 50163.40 646556.54 1152408.93 56%
> 13 26037 cpu 590053.51 49154.31 639207.82 1156177.85 55%
>
> Please help me understand what next steps should I follow to determine the
> bottle neck if any
>
> Regards,
> Vikas
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

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.