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: IDS 12.10 - Query Slow

Posted By: MOHD FADZIL JUSOH
Date: Thursday, 10 November 2016, at 9:49 a.m.

In Response To: Re: IDS 12.10 - Query Slow (Art Kagel)

Hi,

Set ouput from onstat -g iof, Any clue can get from here. Our informix data stored on HP3par storage (raid 10).

IBM Informix Dynamic Server Version 12.10.FC6AEE -- On-Line -- Up 12:10:44 -- 12568132 Kbytes

AIO global files:
gfd pathname bytes read page reads bytes write page writes io/s
3 rootdb 66381824 32413 4335616 2116 1000.4

op type count avg. time

seeks 6781 0.0000

reads 6172 0.0010

writes 609 0.0006

kaio_reads 0 N/A

kaio_writes 0 N/A

4 phydbs 374784 183 1275959296 623027 372.9

op type count avg. time

seeks 2465 0.0000

reads 16 0.0019

writes 2449 0.0027

kaio_reads 0 N/A

kaio_writes 0 N/A

5 logdbs 3657684992 1785979 3601643520 1758615 2973.4

op type count avg. time

seeks 750658 0.0000

reads 55794 0.0005

writes 694866 0.0003

kaio_reads 0 N/A

kaio_writes 0 N/A

6 tempdbs1 135933952 66374 390934528 190886 1952.7

op type count avg. time

seeks 16698 0.0000

reads 4490 0.0006

writes 12208 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

7 tempdbs2 236722176 115587 236109824 115288 1848.3

op type count avg. time

seeks 12136 0.0000

reads 4498 0.0006

writes 7638 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

8 tempdbs3 129783808 63371 130551808 63746 1839.3

op type count avg. time

seeks 7991 0.0000

reads 3986 0.0006

writes 4005 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

9 tempdbs4 675790848 329976 178810880 87310 1607.3

op type count avg. time

seeks 10662 0.0000

reads 5057 0.0007

writes 5605 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

10 datadb1 22864973824 11164492 4096 2 646.0

op type count avg. time

seeks 525362 0.0000

reads 525360 0.0015

writes 2 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

11 datadb2 11901730816 5811392 1329152 649 1874.2

op type count avg. time

seeks 184598 0.0000

reads 184551 0.0005

writes 47 0.0006

kaio_reads 0 N/A

kaio_writes 0 N/A

12 datadb3 13818204160 6747033 213063680 104009 981.1

op type count avg. time

seeks 2864471 0.0000

reads 2839332 0.0010

writes 25119 0.0004

kaio_reads 0 N/A

kaio_writes 0 N/A

13 datadb4 21385355264 10442061 33404928 16311 1347.8

op type count avg. time

seeks 723595 0.0000

reads 721981 0.0007

writes 1616 0.0006

kaio_reads 0 N/A

kaio_writes 0 N/A

14 datadb5 11906574336 5813757 1355776 662 1858.9

op type count avg. time

seeks 184673 0.0000

reads 184625 0.0005

writes 48 0.0009

kaio_reads 0 N/A

kaio_writes 0 N/A

15 datadb6 86321807360 42149296 2887680 1410 714.2

op type count avg. time

seeks 643764 0.0000

reads 643179 0.0014

writes 559 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

16 datadb7 35387031552 17278800 224139264 109432 2439.5

op type count avg. time

seeks 1133251 0.0000

reads 1123923 0.0004

writes 9326 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

17 datadb8 32665298944 15949693 1609101312 785694 2187.9

op type count avg. time

seeks 1079128 0.0000

reads 1029676 0.0005

writes 49455 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

18 idxdbs1 5917722624 2889513 21497856 10497 1040.9

op type count avg. time

seeks 115022 0.0000

reads 111386 0.0010

writes 3636 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

19 idxdbs2 17926295552 8753073 16064512 7843 1398.3

op type count avg. time

seeks 563489 0.0000

reads 558448 0.0007

writes 5038 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

20 idxdbs3 4928724992 2406603 2983936 1456 689.9

op type count avg. time

seeks 261116 0.0000

reads 260011 0.0015

writes 1121 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

21 idxdbs4 11074490368 5407466 151756800 74095 911.6

op type count avg. time

seeks 357505 0.0000

reads 347656 0.0011

writes 9849 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

22 idxdbs21 4671485952 2280999 141312 69 1852.5

op type count avg. time

seeks 72570 0.0000

reads 72521 0.0005

writes 49 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

23 datadb12 4573970432 2233384 5255168 2566 1045.0

op type count avg. time

seeks 78913 0.0000

reads 78749 0.0010

writes 164 0.0009

kaio_reads 0 N/A

kaio_writes 0 N/A

24 idxdbs22 9899546624 4833762 9295872 4539 1888.2

op type count avg. time

seeks 678854 0.0000

reads 676487 0.0005

writes 2366 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

25 datadb61 4554119168 2223686 1101824 538 716.8

op type count avg. time

seeks 83238 0.0000

reads 82905 0.0014

writes 338 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

26 idxdbs31 1090973696 532700 3360768 1641 559.2

op type count avg. time

seeks 62903 0.0000

reads 61986 0.0018

writes 919 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

27 datadb62 25801230336 12598233 101709824 49645 2159.7

op type count avg. time

seeks 2571658 0.0000

reads 2550258 0.0005

writes 21398 0.0004

kaio_reads 0 N/A

kaio_writes 0 N/A

28 datadb71 16124940288 7873490 15937536 7778 2394.5

op type count avg. time

seeks 475715 0.0000

reads 473587 0.0004

writes 2131 0.0004

kaio_reads 0 N/A

kaio_writes 0 N/A

29 datadb9 13065885696 6379825 4251648 2076 1059.3

op type count avg. time

seeks 309285 0.0000

reads 308292 0.0009

writes 996 0.0006

kaio_reads 0 N/A

kaio_writes 0 N/A

30 idxdbs9 15179673600 7411950 22431744 10945 851.4

op type count avg. time

seeks 353725 0.0000

reads 346917 0.0012

writes 6808 0.0005

kaio_reads 0 N/A

kaio_writes 0 N/A

31 datadb22 6144 3 0 0 196.5

op type count avg. time

seeks 3 0.0000

reads 3 0.0051

writes 0 N/A

kaio_reads 0 N/A

kaio_writes 0 N/A

32 datadb52 6144 3 0 0 157.6

op type count avg. time

seeks 3 0.0000

reads 3 0.0063

writes 0 N/A

kaio_reads 0 N/A

kaio_writes 0 N/A

33 datadb63 6144 3 0 0 284.3

op type count avg. time

seeks 3 0.0000

reads 3 0.0035

writes 0 N/A

kaio_reads 0 N/A

kaio_writes 0 N/A

34 life.1553

Please advice. Can we improve IO? Which configuration need to change?

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.