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

Posted By: ROBERT LANGHAMMER
Date: Thursday, 29 November 2007, at 8:30 a.m.

In Response To: RE: RE: Update from Digital 7.31.FD1to .... (Murray Wood)

onstat -p

Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:15:40 -- 2039808 Kbytes

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
57290910 204865922 33221652373 99.83 4158407 37102592 18757603 77.83

isamtot open start read write rewrite delete commit rollbk
67619352616 32820763 268090029 30179662322 2303489 1009986 1091525 1093811 62

gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0

ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 415904.13 12668.70 401 802

bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
7929150 109 431756709 0 0 803 263556 741805

ixda-RA idx-RA da-RA RA-pgsused lchwaits
16862601 14500295 3733907 34174026 1920881
***********
>onstat -g seg

Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:16:38 -- 2039808 Kbytes

Segment Summary:
id key addr size ovhd class blkused blkfree
1 1381451777 200000000 721420288 40480 R 87379 685
2 1381451778 22b000000 1132462080 17840 V 124683 13557
3 1381451779 26e800000 58720256 1456 V 6094 1074
4 1381451780 272000000 58720256 1456 V 6052 1116
5 1381451781 275800000 58720256 1456 V 5283 1885
6 1381451782 279000000 58720256 1456 V 1761 5407
Total: - - 2088763392 - - 231252 23724
********
onstat -d

Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:18:20 -- 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 size free bpages flags pathname
22b07e2a8 1 1 0 20000 4529 PO- /dev/syschunk
22b07e9c0 2 2 20000 200000 4947 PO- /dev/syschunk
22b07ead8 3 3 220000 150000 447 PO- /dev/syschunk
22b07ebf0 4 4 370000 200000 184405 PO- /dev/syschunk
22b07ed08 5 5 50 1000000 75 PO- /dev/datchunk18
22b07ee20 6 5 50 1000000 267 PO- /dev/datchunk25
22b07ef38 7 5 50 1000000 500 PO- /dev/datchunk10
22b07f050 8 5 50 1000000 0 PO- /dev/datchunk14
22b07f168 9 5 50 1000000 464 PO- /dev/datchunk31
22b07f280 10 5 50 1000000 104 PO- /dev/datchunk6
22b07f398 11 5 0 1000000 191 PO- /dev/datchunk19
22b07f4b0 12 6 0 313000 290629 PO- /dev/datchunk17
22b07f5c8 13 5 0 1000000 860 PO- /dev/datchunk26
22b07f6e0 14 5 0 1000000 322 PO- /dev/datchunk11
22b07f7f8 15 5 0 1000000 9324 PO- /dev/datchunk15
22b07f910 16 7 0 1000000 148985 PO- /dev/datchunk20
22b07fa28 17 7 0 1000000 433 PO- /dev/datchunk27
22b07fb40 18 7 0 1000000 151 PO- /dev/datchunk12
22b07fc58 19 7 0 1000000 4 PO- /dev/datchunk16
22b07fd70 20 7 0 1000000 1 PO- /dev/datchunk32
22b07fe88 21 7 0 1000000 580797 PO- /dev/datchunk7
22b0b8850 22 5 0 1000000 11148 PO- /dev/datchunk8
22b0b8968 23 5 0 1000000 12445 PO- /dev/datchunk21
22b0b8a80 24 5 0 1000000 12551 PO- /dev/datchunk28
22b0b8b98 25 5 0 1000000 890 PO- /dev/datchunk22
22b0b8cb0 26 7 0 1000000 263851 PO- /dev/datchunk23
22b0b8dc8 27 8 0 1000000 789 PO- /dev/datchunk2
22b0b8ee0 28 5 0 1000000 5669 PO- /dev/datchunk4
22b0b8ff8 29 7 0 1000000 16934 PO- /dev/datchunk24
22b0b9110 30 5 0 5000 121 PO- /dev/datchunk33
22b0b9228 31 5 0 1000000 12244 PO- /dev/datchunk29
22b0b9340 32 5 0 1000000 11573 PO- /dev/datchunk30
22b0b9458 33 5 25 1000000 12559 PO- /dev/datchunk34
22b0b9570 34 5 25 1000000 8278 PO- /dev/datchunk41
22b0b9688 35 5 25 1000000 5095 PO- /dev/datchunk48
22b0b97a0 36 5 0 1000000 27898 PO- /dev/datchunk55
22b0b98b8 37 8 0 1000000 30925 PO- /dev/datchunk36
22b0b99d0 38 6 5000 235000 234997 PO- /dev/datchunk33
22b0b9ae8 39 4 240000 231000 230997 PO- /dev/datchunk33
22b0b9c00 40 5 0 1000000 14503 PO- /dev/datchunk62
22b0b9d18 41 5 0 1000000 133897 PO- /dev/datchunk42
22b0b9e30 42 8 0 1000000 999997 PO- /dev/datchunk35
22b0c9c50 43 7 0 1000000 18247 PO- /dev/datchunk5
22b0c9d68 44 7 0 1000000 5953 PO- /dev/datchunk37
22b0c9e80 45 7 0 1000000 35599 PO- /dev/datchunk43
22bd34028 46 7 0 1000000 340600 PO- /dev/datchunk49
22bd34140 47 7 0 1000000 550323 PO- /dev/datchunk56
22bd34258 48 7 0 1000000 985260 PO- /dev/datchunk44
22bd34370 49 7 0 1000000 999997 PO- /dev/datchunk50
22bd34488 50 9 0 1000000 223157 PO- /dev/datchunk38
22bd345a0 51 5 0 1000000 60421 PO- /dev/datchunk57
22bd346b8 52 5 0 1000000 180439 PO- /dev/datchunk63
22bd347d0 53 5 0 1000000 14533 PO- /dev/datchunk58
22bd348e8 54 2 0 1000000 694997 PO- /dev/datchunk45
54 active, 2047 maximum
************
onstat -m

Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:18:51 -- 2039808 Kbytes

Message Log File: /informix/online.log
13:47:04 Checkpoint loguniq 360397, logpos 0x36b018

13:57:08 Checkpoint Completed: duration was 5 seconds.
13:57:08 Checkpoint loguniq 360397, logpos 0x11d2018

14:00:21 Logical Log 360397 Complete.
14:00:22 Logical Log 360397 - Backup Started
14:00:39 Logical Log 360397 - Backup Completed
14:07:11 Checkpoint Completed: duration was 1 seconds.
14:07:11 Checkpoint loguniq 360398, logpos 0xa0f14c

14:13:46 Logical Log 360398 Complete.
14:13:47 Logical Log 360398 - Backup Started
14:14:08 Logical Log 360398 - Backup Completed
14:17:12 Checkpoint Completed: duration was 1 seconds.
14:17:12 Checkpoint loguniq 360399, logpos 0x240018

14:27:14 Checkpoint Completed: duration was 1 seconds.
14:27:14 Checkpoint loguniq 360399, logpos 0xd8c018
*************
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

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.