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: Update from Digital 7.31.FD1to ....

Posted By: Art S. Kagel (Oninit LLC)
Date: Thursday, 29 November 2007, at 9:51 a.m.

In Response To: Re: RE: RE: Update from Digital 7.31.FD1to .... (ROBERT LANGHAMMER)

ROBERT LANGHAMMER wrote:

I think that your biggest problem is your disk layout. You have rootdb,
physical logs, logical logs and one of your temp dbspaces all defined on
the same device /dev/syschunk and you are POUNDING on the tempdb
spaces. A few other chunks are being hit hard also, namely
/dev/datachunk6, 17, 26, 21,22,4,29,30,34,41,48,55,62, & 63. Those 18
chunks (including the four chunks defined on syschunk) are each being
hit with over 4 IO/sec (note that IDS averages IOs over clock time not
elapsed time so these averages are VERY low if they could be compared to
peak IO rates). I hope they are not all defined on the same physical
structure (ie stripe, RAID array, NAS, SAN, etc.) since these rates
indicate that at peak you would likely swamp the throughput capacity of
a single structure and it's channel.

I also note the VERY high temp dbspace activity as highly unusual. Is
is possible that your data distributions are not sufficient or that
there are missing indexes? Are your queries relying heavily on VIEWs,
especially joining VIEWs to other VIEWS and TABLES? Such operations
create temp tables containing intermediate results - notably the results
of the VIEW query to be joined to other results. Do you have ORDER BY
clauses not supported by indexes? If the applications are interactive,
should you be running the queries using FIRST_ROWS optimization to avoid
sorts? Can you increase DBUPSPACE or enable PDQPRIORITY and parallel
sorting (PSORT_NPROCS & PSORT_DBTEMP) to enable in-memory sorting
reducing disk IO loads and improve responsiveness?

Art S. Kagel

> <SNIP>
> onstat -D
>
> Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:19:11 --
> 2039808 Kbytes
>
> Dbspaces
> address number flags fchunk nchunks flags owner name
> 22b07e1c0 1 1 1 1 N informix rootdbs
> 22bd34a00 2 1 2 2 N informix llogdbs
> 22bd34ae8 3 1 3 1 N informix plogdbs
> 22bd34bd0 4 2001 4 2 N T informix tempdbs
> 22bd34cb8 5 1 5 27 N informix datdbs
> 22bd34da0 6 2001 12 2 N T informix tempdbs1
> 22bd34e88 7 1 16 15 N informix testdbs
> 22bd34f70 8 1 27 3 N informix rechnungswesen
> 22bd35058 9 1 50 1 N informix archiv
> 9 active, 2047 maximum
>
> Chunks
> address chk/dbs offset page Rd page Wr pathname
> 22b07e2a8 1 1 0 80788 5018 /dev/syschunk
> 22b07e9c0 2 2 20000 544471 542705 /dev/syschunk
> 22b07ead8 3 3 220000 27 1129461 /dev/syschunk
> 22b07ebf0 4 4 370000 14665828 16276107 /dev/syschunk
> 22b07ed08 5 5 50 3330194 63954 /dev/datchunk18
> 22b07ee20 6 5 50 3693226 91485 /dev/datchunk25
> 22b07ef38 7 5 50 3924806 54026 /dev/datchunk10
> 22b07f050 8 5 50 3005819 5146 /dev/datchunk14
> 22b07f168 9 5 50 2556638 60355 /dev/datchunk31
> 22b07f280 10 5 50 6149285 64578 /dev/datchunk6
> 22b07f398 11 5 0 3351048 81633 /dev/datchunk19
> 22b07f4b0 12 6 0 14660318 16530324 /dev/datchunk17
> 22b07f5c8 13 5 0 5369868 116983 /dev/datchunk26
> 22b07f6e0 14 5 0 2756039 18098 /dev/datchunk11
> 22b07f7f8 15 5 0 3751442 100414 /dev/datchunk15
> 22b07f910 16 7 0 2519886 0 /dev/datchunk20
> 22b07fa28 17 7 0 3020597 0 /dev/datchunk27
> 22b07fb40 18 7 0 2961168 0 /dev/datchunk12
> 22b07fc58 19 7 0 3006185 0 /dev/datchunk16
> 22b07fd70 20 7 0 3002416 0 /dev/datchunk32
> 22b07fe88 21 7 0 1199256 0 /dev/datchunk7
> 22b0b8850 22 5 0 4051669 51109 /dev/datchunk8
> 22b0b8968 23 5 0 4652059 37607 /dev/datchunk21
> 22b0b8a80 24 5 0 4286159 37021 /dev/datchunk28
> 22b0b8b98 25 5 0 6271816 25651 /dev/datchunk22
> 22b0b8cb0 26 7 0 2185444 0 /dev/datchunk23
> 22b0b8dc8 27 8 0 2887002 9856 /dev/datchunk2
> 22b0b8ee0 28 5 0 4735443 49371 /dev/datchunk4
> 22b0b8ff8 29 7 0 2904982 0 /dev/datchunk24
> 22b0b9110 30 5 0 23896 23 /dev/datchunk33
> 22b0b9228 31 5 0 6504509 46304 /dev/datchunk29
> 22b0b9340 32 5 0 7621371 44343 /dev/datchunk30
> 22b0b9458 33 5 25 8388770 84764 /dev/datchunk34
> 22b0b9570 34 5 25 6839096 47487 /dev/datchunk41
> 22b0b9688 35 5 25 7417666 37712 /dev/datchunk48
> 22b0b97a0 36 5 0 11433054 38697 /dev/datchunk55
> 22b0b98b8 37 8 0 3440784 32119 /dev/datchunk36
> 22b0b99d0 38 6 5000 43684 104921 /dev/datchunk33
> 22b0b9ae8 39 4 240000 1 1 /dev/datchunk33
> 22b0b9c00 40 5 0 9674343 352861 /dev/datchunk62
> 22b0b9d18 41 5 0 1600315 27613 /dev/datchunk42
> 22b0b9e30 42 8 0 7 0 /dev/datchunk35
> 22b0c9c50 43 7 0 2927830 0 /dev/datchunk5
> 22b0c9d68 44 7 0 2797774 0 /dev/datchunk37
> 22b0c9e80 45 7 0 2746234 0 /dev/datchunk43
> 22bd34028 46 7 0 1930641 0 /dev/datchunk49
> 22bd34140 47 7 0 1211398 0 /dev/datchunk56
> 22bd34258 48 7 0 42601 0 /dev/datchunk44
> 22bd34370 49 7 0 7 0 /dev/datchunk50
> 22bd34488 50 9 0 1951771 0 /dev/datchunk38
> 22bd345a0 51 5 0 3151076 65447 /dev/datchunk57
> 22bd346b8 52 5 0 6366288 36740 /dev/datchunk63
> 22bd347d0 53 5 0 2517689 60185 /dev/datchunk58
> 22bd348e8 54 2 0 867594 871397 /dev/datchunk45
> 54 active, 2047 maximum
> ************
> onstat -g iof
>
> Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:19:46 --
> 2039808 Kbytes
>
> AIO global files:
> gfd pathname totalops dskread dskwrite io/s
> 3 /dev/syschunk 66682 18 66664 0.3
> 4 /dev/syschunk 482673 17676 464997 2.0
> 5 /dev/syschunk 1162575 570984 591591 4.8
> 6 /dev/syschunk 29021 25161 3860 0.1
> 7 /dev/datchunk18 520232 472544 47688 2.1
> 8 /dev/datchunk25 673667 605816 67851 2.8
> 9 /dev/datchunk10 654100 611712 42388 2.7
> 10 /dev/datchunk14 99915 99328 587 0.4
> 11 /dev/datchunk31 508035 486155 21880 2.1
> 12 /dev/datchunk6 1952558 1898436 54122 8.1
> 13 /dev/datchunk19 377096 333247 43849 1.6
> 14 /dev/datchunk17 1174340 572236 602104 4.8
> 15 /dev/datchunk26 1668881 1588663 80218 6.9
> 16 /dev/datchunk11 208547 195066 13481 0.9
> 17 /dev/datchunk15 804755 728195 76560 3.3
> 18 /dev/datchunk20 125034 125034 0 0.5
> 19 /dev/datchunk27 117503 117503 0 0.5
> 20 /dev/datchunk12 94194 94194 0 0.4
> 21 /dev/datchunk16 101402 101402 0 0.4
> 22 /dev/datchunk32 96175 96175 0 0.4
> 23 /dev/datchunk7 52770 52770 0 0.2
> 24 /dev/datchunk8 938449 899371 39078 3.9
> 25 /dev/datchunk21 1092558 1061818 30740 4.5
> 26 /dev/datchunk28 848405 816846 31559 3.5
> 27 /dev/datchunk22 1258845 1244243 14602 5.2
> 28 /dev/datchunk23 69439 69439 0 0.3
> 29 /dev/datchunk2 240657 235815 4842 1.0
> 30 /dev/datchunk4 1656283 1619342 36941 6.8
> 31 /dev/datchunk24 91429 91429 0 0.4
> 32 /dev/datchunk33 7833 7812 21 0.0
> 33 /dev/datchunk29 2009699 1974065 35634 8.3
> 34 /dev/datchunk30 2882732 2848402 34330 11.9
> 35 /dev/datchunk34 3222037 3160275 61762 13.3
> 36 /dev/datchunk41 2400999 2367021 33978 9.9
> 37 /dev/datchunk48 2963750 2938241 25509 12.2
> 38 /dev/datchunk55 5575715 5543933 31782 23.0
> 39 /dev/datchunk36 394250 369734 24516 1.6
> 40 /dev/datchunk33 5316 1564 3752 0.0
> 41 /dev/datchunk33 2 1 1 0.0
> 42 /dev/datchunk62 2837455 2642187 195268 11.7
> 43 /dev/datchunk42 69913 63961 5952 0.3
> 44 /dev/datchunk35 7 7 0 0.0
> 45 /dev/datchunk5 92389 92389 0 0.4
> 46 /dev/datchunk37 96097 96097 0 0.4
> 47 /dev/datchunk43 86065 86065 0 0.4
> 48 /dev/datchunk49 60477 60477 0 0.2
> 49 /dev/datchunk56 38230 38230 0 0.2
> 50 /dev/datchunk44 1360 1360 0 0.0
> 51 /dev/datchunk50 7 7 0 0.0
> 52 /dev/datchunk38 125698 125698 0 0.5
> 53 /dev/datchunk57 463333 441835 21498 1.9
> 54 /dev/datchunk63 2522922 2496140 26782 10.4
> 55 /dev/datchunk58 715618 691408 24210 3.0
> 56 /dev/datchunk45 617802 28311 589491 2.5
>
>
> *******************************************************************************
> 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.