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: VPCLASS cpu on sun/oracle M4000 machine

Posted By: GERARDO PADIERNA
Date: Wednesday, 24 August 2011, at 4:36 a.m.

In Response To: Re: VPCLASS cpu on sun/oracle M4000 machine (Art Kagel)

Hi Art,
both of them:
VPCLASS cpu,num=16,aff=(1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31),noage
VPCLASS cpu,num=32,aff=(1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31),noage
work (as I told Dave, I understand what I was doing wrong with the VPCLASS syntax). But despite of the fact that now upon boot-up informix reports correctly:
09:04:37 Affinitied VP 1 to phys proc 1
09:04:37 Affinitied VP 3 to phys proc 3
09:04:37 Affinitied VP 4 to phys proc 5
09:04:37 Affinitied VP 5 to phys proc 7
09:04:37 Affinitied VP 6 to phys proc 9
09:04:37 Affinitied VP 7 to phys proc 11
09:04:37 Affinitied VP 8 to phys proc 13
09:04:38 Affinitied VP 9 to phys proc 15
09:04:38 Affinitied VP 10 to phys proc 17
09:04:38 Affinitied VP 11 to phys proc 19
09:04:38 Affinitied VP 12 to phys proc 21
09:04:38 Affinitied VP 13 to phys proc 23
09:04:38 Affinitied VP 14 to phys proc 25
09:04:38 Affinitied VP 15 to phys proc 27
09:04:38 Affinitied VP 16 to phys proc 29
09:04:38 Affinitied VP 17 to phys proc 31
09:04:38 Affinitied VP 18 to phys proc 1
09:04:39 Affinitied VP 19 to phys proc 3
09:04:39 Affinitied VP 20 to phys proc 5
09:04:39 Affinitied VP 21 to phys proc 7
09:04:39 Affinitied VP 22 to phys proc 9
09:04:39 Affinitied VP 23 to phys proc 11
09:04:39 Affinitied VP 24 to phys proc 13
09:04:39 Affinitied VP 25 to phys proc 15
09:04:39 Affinitied VP 26 to phys proc 17
09:04:39 Affinitied VP 27 to phys proc 19
09:04:39 Affinitied VP 28 to phys proc 21
09:04:40 Affinitied VP 29 to phys proc 23
09:04:40 Affinitied VP 30 to phys proc 25
09:04:40 Affinitied VP 31 to phys proc 27
09:04:40 Affinitied VP 32 to phys proc 29
09:04:40 Affinitied VP 33 to phys proc 31

still, during the unload process, CPU usage, as shown by prstat -a isn't any higher as 1,3 - 1.4%:
$ prstat -a
(...)

221 root 20M 7360K sleep 59 0 0:02:53 0,0% devfsadm/8
NPROC USERNAME SWAP RSS MEMORY TIME CPU

81 informix 4648M 4191M 13% 30:54:07 1,4%

82 root 607M 427M 1,3% 49:51:03 0,1%

3 webspher 1994M 1842M 5,6% 23:32:02 0,0%

1 mancbrid 92M 97M 0,3% 1:38:36 0,0%

1 smmsp 2080K 5864K 0,0% 0:01:24 0,0%

1 tomapp 124M 94M 0,3% 0:48:18 0,0%

1 noaccess 126M 140M 0,4% 1:29:34 0,0%

5 daemon 6768K 8864K 0,0% 0:17:25 0,0%

and, after a while, the onstat -g glo | cpu output shows this:
vp pid class usercpu syscpu total Thread Eff
1 8291 cpu 81.46 71.62 153.08 549.35 27%
3 8334 cpu 84.16 79.51 163.67 624.29 26%
4 8335 cpu 108.68 135.33 244.01 1129.99 21%
5 8336 cpu 79.91 106.29 186.20 887.67 20%
6 8337 cpu 34.93 47.13 82.06 320.40 25%
7 8338 cpu 29.55 39.13 68.68 250.40 27%
8 8339 cpu 21.36 27.03 48.39 182.10 26%
9 8340 cpu 13.41 17.38 30.79 115.30 26%
10 8341 cpu 5.44 5.30 10.74 38.62 27%
11 8342 cpu 2.54 2.35 4.89 19.08 25%
12 8343 cpu 1.07 0.89 1.96 7.50 26%
13 8344 cpu 0.43 0.42 0.85 3.20 26%
14 8345 cpu 0.24 0.30 0.54 1.54 35%
15 8346 cpu 0.08 0.09 0.17 0.31 55%
16 8347 cpu 0.03 0.07 0.10 0.10 100%
17 8348 cpu 0.03 0.09 0.12 0.12 100%
18 8349 cpu 0.03 0.05 0.08 0.08 100%
19 8350 cpu 0.03 0.04 0.07 0.00 0%
20 8351 cpu 0.02 0.03 0.05 0.00 0%
21 8352 cpu 0.02 0.03 0.05 0.00 0%
22 8353 cpu 0.03 0.04 0.07 0.00 0%
23 8354 cpu 0.03 0.03 0.06 0.00 0%
24 8355 cpu 0.03 0.03 0.06 0.00 0%
25 8356 cpu 0.03 0.03 0.06 0.00 0%
26 8357 cpu 0.03 0.04 0.07 0.00 0%
27 8358 cpu 0.03 0.04 0.07 0.00 0%
28 8359 cpu 0.03 0.04 0.07 0.00 0%
29 8360 cpu 0.03 0.03 0.06 0.00 0%
30 8361 cpu 0.03 0.04 0.07 0.00 0%
31 8362 cpu 0.02 0.03 0.05 0.00 0%
32 8363 cpu 0.02 0.03 0.05 0.00 0%
33 8364 cpu 0.02 0.03 0.05 0.00 0%

You can see the usercpu and syscpu columns are almost for most of the cpu VP, so I think it's obviously not using more than 8 to 10 cpu VP. Why doesn't it use more CPU power?

The BTR, calculated according to what you explain here:
http://www.dbmonster.com/Uwe/Forum.aspx/informix/3869/Informix-Performance-Issues
is:
Pagreads: 263011805
Bufwrits: 27528339
Bufwaits: 842113
BUFFERS: 1024000
Time since reset: 113.0
ixda-RA: 3813274
idx-RA: 8352
da-RA: 7911577
RA-pgsused: 11529856
_________________________
BTR = ((27528339 + 263011805)/1024000)/113.0 = 2.51/hour

(I have a doubt here: is the first term for BTR Bufwrits or Bufwaits? I used Bufwrites).

Update:
I've just tested a different approach here: until now I was doing just one 'unload to <file> select * ...'. I've launched several simultaneous unloads and there the CPU usage goes up. I did 11 unloads and CPU went up to around 15%, which is roughly:
1.3% CPU usage per unload * 11 unloads = 14.3%
In this way I managed to unload 61GB data in 25min, whereas in a single unload it takes about 3h,30min. I will have to have a closer look at this simultaneous unloads to make it work safely, without data loss, but this is a different story.

So it seems clear to me know that for whatever reason this machine, with the configuration I have, doesn't use more than about 1/2 a thread per unload process (if it used up 1 whole cpu thread per unload one should expect about 1/32*100 = 3.125% CPU usage, but there's only half of it...).

Cheers!

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.