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

High CPU IO Wait

Posted By: ARBA STEVEN
Date: Tuesday, 9 January 2018, at 8:01 a.m.

Hi,
We are having recently having some CPU IO Wait issues. The CPU IO Wait value stays arount 15% .
I've also noticed that CPU Eff is very low:

IBM Informix Dynamic Server Version 12.10.FC7 -- On-Line -- Up 231 days 02:25:26 -- 5343628 Kbytes

MT global info:
sessions threads vps lngspins time
55 112 31 38 260806

sched calls thread switches yield 0 yield n yield forever
total: 3209079298 3953281725 271323002 213364796 510946501
per sec: 4345841 12278 4334915 542 4195

Virtual processor summary:
class vps usercpu syscpu total
cpu 10 148357.28 11552.33 159909.61
aio 5 6.29 87.65 93.94
lio 1 0.24 0.51 0.75
pio 1 0.40 0.73 1.13
adm 1 5.10 5.30 10.40
soc 1 1833.92 3178.71 5012.63
msc 1 0.06 0.05 0.11
crypto 10 2555.36 196.35 2751.71
fifo 1 0.24 0.58 0.82
total 31 152758.89 15022.21 167781.10

Individual virtual processors:
vp pid class usercpu syscpu total Thread Eff
1 12026 cpu 30532.56 2848.88 33381.44 61215.75 54%
2 12027 adm 5.10 5.30 10.40 0.00 0%
3 12028 lio 0.24 0.51 0.75 0.00 0%
4 12029 pio 0.40 0.73 1.13 0.00 0%
5 12030 aio 4.85 83.89 88.74 431.46 20%
6 12031 msc 0.06 0.05 0.11 0.61 18%
7 12032 fifo 0.24 0.58 0.82 0.00 0%
8 12033 cpu 23771.06 2078.80 25849.86 50232.95 51%
9 12034 cpu 20413.37 1491.44 21904.81 43167.55 50%
10 12035 cpu 15906.21 1280.29 17186.50 33191.59 51%
11 12036 cpu 12555.32 972.54 13527.86 26927.19 50%
12 12037 cpu 11260.30 719.93 11980.23 22081.00 54%
13 12038 cpu 9577.72 604.43 10182.15 18237.37 55%
14 12039 cpu 8613.38 502.04 9115.42 16041.61 56%
15 12040 cpu 8653.01 506.41 9159.42 17372.45 52%
16 12041 cpu 7074.35 547.57 7621.92 13583.73 56%
17 12042 crypto 2552.29 190.75 2743.04 2743.04 100%
18 12043 crypto 0.32 0.63 0.95 0.00 0%
19 12044 crypto 0.42 0.66 1.08 0.00 0%
20 12045 crypto 0.29 0.58 0.87 0.00 0%
21 12046 crypto 0.33 0.60 0.93 0.00 0%
22 12047 crypto 0.26 0.60 0.86 0.00 0%
23 12048 crypto 0.40 0.70 1.10 0.00 0%
24 12049 crypto 0.39 0.72 1.11 0.00 0%
25 12050 crypto 0.36 0.62 0.98 0.00 0%
26 12051 crypto 0.30 0.49 0.79 0.00 0%
27 12052 soc 1833.92 3178.71 5012.63 NA NA
28 12053 aio 0.35 0.90 1.25 2.21 56%
29 12054 aio 0.34 1.04 1.38 1.38 100%
30 14967 aio 0.36 0.97 1.33 1.33 100%
31 32478 aio 0.39 0.85 1.24 1.24 100%

tot 152758.89 15022.21 167781.10

Always when there is a such high CPU IO Wait I can see lots of KAIO threads in active threads:
Running threads:
tid tcb rstcb prty status vp-class name
8 4aec4800 0 1 running 27soc* soctcppoll
30 4b31b8b0 0 3 running 1cpu* kaio
55 4b58dd28 0 3 running 9cpu* kaio
68 4b803178 0 3 running 10cpu* kaio
69 4b8034b8 0 3 running 11cpu* kaio
70 4b989608 0 3 running 12cpu* kaio
71 4b8037f8 0 3 running 13cpu* kaio
98 4bb73028 0 3 running 14cpu* kaio

Thank you.

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.