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: AW: How to check informix DB bottlenecks

Posted By: JACK PAPA
Date: Tuesday, 2 March 2010, at 4:37 a.m.

In Response To: AW: How to check informix DB bottlenecks (Andreas.KUTSCHE@spar.at)

I am using IDS 9.4, AIX 5.4.

onstat -p shows

=> onstat -p

IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line (Prim) -- Up 23 days 15:06:08 -- 2251504 Kbytes

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
1220612817 3198664750 2251555606 45.79 34109654 100095460 2062133360 98.35

isamtot open start read write rewrite delete commit rollbk
2936740675 208936934 1093068317 2477580096 1270145450 25498127 26444677 3868723 1868

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 723695.11 86056.10 8699 17400

bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
51876197 7247 1280409663 57 0 12432 6247517 15715161

ixda-RA idx-RA da-RA RA-pgsused lchwaits
85766244 103708265 208434932 366985387 3557149

-------------------------
This is the onstat -u output.

90291c30 ---P--- 12 informix - 0 0 0 0 34
90292248 ---P--B 13 informix - 0 0 0 392183594 777296
90292860 Y--P--D 15 informix - 908b4540 0 0 30027 8701
90292e78 ---P--D 35290 informix - 0 0 0 0 0
90293490 ---P--D 35289 informix - 0 0 0 0 0
902946d8 ---P--D 20 informix - 0 0 0 0 8
90295308 Y--P--- 25 patrol - 913b0a18 0 16 54299002 1142837
90295920 Y--P--D 26 informix - 4008f12c 0 0 0 0
90296550 Y-AP--M 106804 informix - 93b6a888 0 0 29 24
90297180 Y--P--- 106500 user1 0 93968f18 0 1 6 79
902983c8 Y--P--- 105021 user1 Server01 984162a0 0 1 396 285
90299c28 Y--P--- 102768 user1 Server01 936296f8 0 1 0 151
9029a240 Y--P--- 76613 user001 - 92c7ba18 0 2 808003 0
9029eb60 Y--P--- 76570 user001 - 93b51d38 0 1 1717 588
902a1c20 Y--P--- 103621 user1 Server01 931bb798 0 1 0 12
902a2e68 Y--P--- 106557 user001 - 9242afb8 0 1 51 0
902a6540 Y-AP--M 106805 informix - 96892ba8 0 0 26 24
902a7da0 Y--P--- 2788 user1 0 94821068 0 1 7706567 1542817
902a89d0 Y--P--- 2789 user1 0 9397b158 0 1 1552 57902
902a9600 Y--P--- 2776 user1 Server04 9398e068 0 1 11094 125827
93302018 Y--P--- 2781 user1 Server04 9155d9e0 0 1 0 0
933044a8 Y--P--- 20454 user1 0 931a5fc8 0 2 39585 2843
93304ac0 Y--P--- 105783 user1 Server01 937422e8 0 1 1262 674
93306320 Y--P--- 106798 user1 0 93bb4b58 0 1 2 95
93307568 Y--P--- 103615 user1 Server01 93a55fb8 0 1 299 217
93307b80 Y--P--- 106131 user1 Server01 9364ed88 0 1 69 1482
9330a010 Y--P--- 105251 user1 0 936ad608 0 1 1 1
9330b870 Y--P--- 106481 user1 Server01 9c11d658 0 1 0 40
9330d6e8 Y--P--- 106384 user1 Server01 92cb7ce0 0 1 2811 2612
9330f560 Y--P--- 106748 user1 Server01 93aa03d8 0 1 0 34
9330fb78 Y--P--- 106795 user1 0 930b1bf8 0 4 10345 809
93312620 Y-AP--M 106803 informix - 92139d38 0 0 27 24
93313e80 Y--P--- 106540 user001 - 939b39c8 0 1 67 0
933150c8 Y--P--- 99281 user1 0 9efd4478 0 1 1 17
933156e0 Y--P--- 99279 user1 0 9c9158d8 0 2 1 1
93315cf8 Y--P--- 106547 user001 - 91c43428 0 1 623 588
93316928 Y--P--- 104952 user1 Server01 9c012108 0 1 808 670
93316f40 Y--P--- 21824 user1 Server02 93943928 0 1 0 0
93317b70 Y--P--- 70141 user002 - 935cbf68 0 1 61964 4102
933193d0 Y--P--- 104992 user1 0 9378f798 0 1 0 1
9331ac30 Y--P--- 101838 user1 Server01 91271338 0 1 26147 7592
9331c490 ------- 106803 informix - 0 0 0 0 0
9331caa8 Y--P--- 101997 user1 Server01 92de41f8 0 1 2836 2608
9331e920 Y--P--- 41847 user1 0 93876e28 0 4 46627 3466
9331ef38 ------- 106807 informix - 0 0 0 298 0
933219e0 Y--P--- 106639 user1 0 9377a1a8 0 1 5 3
93321ff8 ------- 106812 informix - 0 0 0 298 0
93322610 Y--P--- 104990 user1 0 937a94c8 0 2 5 1
93322c28 Y--P--- 102590 user1 Server01 93c14298 0 1 0 0
93323e70 Y--P--- 105250 user1 Server68 938be978 0 1 0 0
93324aa0 Y--P--- 103041 user1 0 93884608 0 1 304442 75051
933250b8 Y--P--- 106136 user001 - 92de4b58 0 2 44 0
93326300 Y--P--- 104816 user1 Server01 9afb0428 0 1 829 205
9332c480 ------- 106811 informix - 0 0 0 0 0
9332d0b0 Y--P--- 76578 user001 - 9f9f7338 0 1 785 588
93330788 Y--P--- 106711 user1 0 9369a518 0 1 9 26
97e90e90 Y--P--- 106556 user001 - 93b51338 0 1 629 588
97e92d08 Y--P--- 103382 user1 0 939d8338 0 3 6956 226
97e93938 Y-AP--M 106812 informix - 93b37658 0 0 26 24
97e94568 Y--P--- 106546 user001 - 98496568 0 1 6 0
97e95dc8 Y--P--- 106210 user1 Server01 9c333ab8 0 1 0 43
97e98e88 Y--P--- 101889 user1 Server01 93a235b8 0 1 137 178
97e9b930 Y--P--- 100041 user1 0 937d4d88 0 1 5691 109
97e9cb78 Y--P--- 105010 user001 - 93848248 0 1 3934 1708
97e9d190 Y--P--- 104993 user1 Server69 93943978 0 1 0 0
97e9d7a8 Y--P--- 105244 user1 0 93867518 0 2 3 1
97e9e3d8 Y--P--- 76573 user001 - 936f7e78 0 1 76 0
97e9e9f0 Y--P--- 106582 user1 0 9f124a68 0 1 6 4
97ea0868 Y-AP--M 106808 informix - 93ab33d8 0 0 27 24
97ea26e0 ------- 106804 informix - 0 0 0 5 0
97ea3310 Y--P--- 70711 user003 Server12 93593dd8 0 1 18318 0
97ea3928 Y--P--- 106548 user001 - 93c6d838 0 1 12 0
97ea3f40 Y-AP--M 106807 informix - 930e0018 0 0 27 24
97ea5db8 Y--P--- 106209 user1 Server01 93c01068 0 1 181 185
97ea63d0 Y-AP--M 106811 informix - 9242a158 0 0 27 24
97eaa0c0 Y--P--- 20457 user1 0 93a11888 0 1 259723 1105
97eab308 Y-AP--M 106810 informix - 9b9b3298 0 0 27 24
97eab920 Y--P--- 104953 user1 Server01 937e3978 0 1 0 51
97eac550 Y--P--- 106560 user1 0 9171be28 0 2 247 137
97eae3c8 Y--P--- 103642 user1 Server01 9d62dc98 0 1 669 408
97eb0e70 Y--P--- 106387 user1 Server01 93c5fbf8 0 1 0 54
97eb1488 ------- 106806 informix - 0 0 0 304 0
97eb2ce8 ------- 106804 informix - 0 0 0 0 0
97eb3300 Y--P--- 103643 user1 Server01 93a11518 0 1 0 2
97eb7608 ------- 106808 informix - 0 0 0 298 0
97eba6c8 Y--P--- 101797 user1 Server01 939a0ce8 0 1 0 296
97ebbf28 Y--P--- 106545 user001 - 935de608 0 1 624 588
97ebd788 Y--P--- 76610 user001 - 93c27478 0 1 8037 2268
97ebefe8 ------- 106811 informix - 0 0 0 298 0
99b19c48 Y--P--- 106552 user001 - 9f40e928 0 1 620 588
99b1ae90 Y--P--- 101839 user1 Server01 9381d798 0 1 0 192
99b1b4a8 Y--P--- 71661 user003 Server12 9f4459c8 0 1 27579 0
99b1d938 Y--P--- 106553 user001 - 93c396a8 0 1 63 0
99b1fdc8 ------- 106806 informix - 0 0 0 0 96
99b21628 Y--P--- 104918 user001 - 936adce8 0 1 3964 1148
99b21c40 Y--P--- 102962 user1 0 93857928 0 1 61 3672
99b25318 Y--P--- 99276 user1 Server96 937b8388 0 1 0 0
99b25930 Y--P--- 86450 user1 0 9398e478 0 1 68882 251
99b26b78 Y--P--- 106369 user1 Server01 93aa0e78 0 1 0 0
99b277a8 Y--P--- 101892 user1 Server01 933980b8 0 1 0 0
99b27dc0 Y--P--- 82213 user001 - 9f545018 0 2 6172 0
99b283d8 Y--P--- 73755 user003 Server10 938393d8 0 1 16090 0
99b2a868 Y--P--- 105011 user001 - 9379b658 0 2 82569 0
99b2c0c8 Y--P--- 106791 user1 Server01 936e5338 0 1 48 122
99b2c6e0 ------- 106805 informix - 0 0 0 3 0
99b2e558 Y--P--- 103724 user1 Server01 9afb0928 0 1 56 27
99b2eb70 Y--P--- 105826 user1 0 930e0738 0 3 2059 198
99b2f188 Y--P--- 85998 user002 - 937c6bf8 0 1 25882 2218
99b309e8 Y--P--- 86447 user1 0 939d8658 0 2 26812 601
99b31000 Y--P--- 106561 user1 0 9377a478 0 1 6 4
99b32248 Y--P--- 102872 user1 Server05 936adb08 0 1 0 0
99b34cf0 Y--P--- 103725 user1 Server01 9c74ea18 0 1 0 6
99b35308 Y--P--- 106135 user001 - 9379bab8 0 1 2882 1148
99b35920 Y--P--- 106792 user1 Server01 9314c8d8 0 1 0 6
99b36b68 Y--P--- 102767 user1 Server01 935cb658 0 1 1789 990
99b37180 Y--P--- 104666 user1 Server01 9f8c04c8 0 1 0 0
99b37db0 Y--P--- 106538 user001 - 936d2978 0 1 640 588
99b39610 Y--P--- 105253 user1 Server68 9379b8d8 0 1 0 0
99b3cce8 Y--P--- 102416 user1 Server01 9b90f108 0 1 0 18
99b3d300 Y-AP--M 106780 informix - 918e4428 0 1 59 26
99b42e68 ------- 106805 informix - 0 0 0 0 0
99b43a98 Y--P--- 106747 user1 Server01 92139748 0 1 145 302
99b440b0 Y--P--- 105312 user1 0 9f9b0ce8 0 3 9406 733
99b45f28 ------- 106807 informix - 0 0 0 0 0
99b46b58 Y--P--- 102871 user1 Server11 93a11fb8 0 1 378 6738
99b47170 Y--P--- 102671 rbisn00 3 93956748 0 1 101 0
99b489d0 Y--P--- 104665 user1 Server01 939fece8 0 1 96 80
9cceb6f0 Y--P--- 41857 user1 0 93c27338 0 1 205145 1058
9ccec320 Y--P--- 106480 user1 Server01 9481f3d8 0 1 320 971
9cced568 Y--P--- 106201 user1 Server01 93b51ec8 0 1 1798 1191
9ccee7b0 ------- 106808 informix - 0 0 0 0 0
9cceedc8 Y--P--- 103384 user1 0 9380e1f8 0 1 6467 34
9ccef3e0 Y--P--- 105484 user1 Server01 9fbb8018 0 1 0 0
9ccf1e88 Y--P--- 104980 user1 Server69 98a15b08 0 1 9 0
9ccf36e8 Y--P--- 102960 user1 0 9fbb8a18 0 1 380883 83313
9ccf67a8 Y--P--- 82202 user001 - 93a8d9c8 0 1 4663 1708
9ccf73d8 Y--P--- 99271 user1 Server96 93c27928 0 1 0 0
9ccf79f0 Y--P--- 105483 user1 Server01 9e250ce8 0 1 279 187
9ccf9250 Y-AP--M 106809 informix - 9371d658 0 0 26 24
9ccf9e80 Y--P--- 105827 user1 0 9cd89748 0 1 20 69
9ccfaab0 ------- 106810 informix - 0 0 0 298 0
9ccfcf40 Y--P--- 105605 user1 Server01 9363b4c8 0 1 0 8
9ccfdb70 ------- 106812 informix - 0 0 0 0 0
9ccfe188 ------- 106809 informix - 0 0 0 0 0
9ccff9e8 Y--P--- 106496 user1 0 91271388 0 2 2579 1161
9cd00618 Y--P--- 100038 user1 0 9c3338d8 0 3 44874 554
9cd01e78 Y--P--- 106627 user1 Server01 9377af18 0 1 18 88
9cd036d8 ------- 106809 informix - 0 0 0 298 0
9cd04308 Y--P--- 104937 user1 Server01 9c3abe28 0 1 0 0
9cd04920 Y--P--- 76580 user001 - 93661f18 0 1 64 0
9cd05550 ------- 106803 informix - 0 0 0 4 0
9cd06180 Y--P--- 106202 user1 Server01 9c72e298 0 1 0 73
9cd06798 Y--P--- 21822 user1 Server02 93398bf8 0 1 7071 71595
9cd073c8 Y--P--- 106628 user1 Server01 938f70b8 0 1 0 2
9cd08c28 ------- 106810 informix - 0 0 0 0 0
9cd0b6d0 Y--P--- 106272 user004 7 939fe478 0 1 222495 0
9cd0cf30 Y--P--- 105324 user1 0 939a0bf8 0 1 11259 27
9cd0f9d8 Y--P--- 106368 user1 Server01 933e31a8 0 1 1001 424
9cd11850 Y--P--- 105022 user1 Server01 9b9b37e8 0 1 0 5
9cd12a98 Y-AP--M 106806 informix - 9318edd8 0 0 38 24
9cd136c8 Y--P--- 106708 user1 0 9371d978 0 4 9617 298
9cd13ce0 Y--P--- 101998 user1 Server01 9b370158 0 1 0 50
9cd15540 Y--P--- 102413 user1 Server01 93bc7568 0 1 2921 1713
9cd16da0 Y--P--- 105005 user001 - 9be45a18 0 2 292 18
9cd173b8 Y--P--- 106578 user1 0 927f71f8 0 2 1516 1080
a1312018 Y--P--- 101796 user1 Server01 93ad8bf8 0 1 2156 2477
a1312c48 Y--P--- 103042 user1 0 930b16a8 0 1 89 2889
a13144a8 Y--P--- 102589 user1 Server01 91c43c98 0 1 694 161
a13150d8 Y--P--- 103616 user1 Server01 933584c8 0 1 0 7
a13156f0 Y--P--- 76572 user001 - 9377a018 0 1 0 0
a1315d08 Y--P--- 105784 user1 Server01 91c43388 0 1 0 103
a1316320 Y--P--- 106636 user1 0 9fb54ce8 0 7 198 63
a1317568 Y--P--- 103620 user1 Server01 9f949d38 0 1 4450 2320
a1317b80 Y--P--- 104817 user1 Server01 9364e8d8 0 1 0 12
a13193e0 Y--P--- 106132 user1 Server01 97cb4fb8 0 1 0 111
a131a010 Y--P--- 104936 user1 Server01 9f8c43d8 0 1 4860 13913
a131b258 Y--P--- 89712 user005 2 93b57bf8 0 1 968 84
a131c4a0 Y--P--- 105604 user1 Server01 93c14248 0 1 1899 1001

I can't post the onstat -g sql 0 output as it's too long.

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.