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: Performance Impact after storage migration

Posted By: VIKAS HIVARKAR
Date: Wednesday, 16 October 2013, at 3:26 a.m.

In Response To: Re: Performance Impact after storage migration (Art Kagel)

Hello Art,

We are still facing the timely issue of high response and not sure
It is because of LRU flusing as comapred to Chunk writes OR
It is because of the new disk setup we have implemented.

HP team is working on the issue and as always the HP team says that you need to
check the database bottleneck and the IBM AVL support says you need to check
with HP :(

I took up some of the you queries with the HP team and the response is as

Why 10k rmp and not 15k disk was selected?
They say the new disk has some kind of 2 GB SSD which will enhance the performance
of disk and it is called as Adaptive optimization configuration, BTW they have
not yet enabled this feature as we are having performance issues now.

Raid 1 Vs 5

Yes, 6 DATABASE vgs are on RAID5 but rest all are on RAID 1
I have also asked them to move these 6 to RAID 1 and not have anything
releated to database on RAID 5

They do not understand my question on one single spindle being virtual redundancy
and if it fails then everything fails

Until they break their heads I want to quicky check few things on informix side
I have even rebooted the servers primary and sds just to check if it helps

For sure chunck writes are better than LRU rights but after reboot I see more LRU Writes

prod:/home/vikash $ onstat -F

IBM Informix Dynamic Server Version 11.50.FC8W2 -- On-Line (Prim) -- Up 06:37:30 -- 83208912 Kbytes

Fg Writes LRU Writes Chunk Writes
0 1647079 59511

I am not sure if these intensive writing could be or problem, you recommended
that 0.5 and 2 setting against our current 1 and 5, would it reduce the LRU rights

The onstat -g iof output is too big to post here can you help me understand what portion
in that output will show me the delay in read/writes or a benchmark value below which
we are in trouble

sar -a

HP-UX prodtu B.11.31 U ia64 10/16/13

00:00:00 iget/s namei/s dirbk/s
00:05:00 2 803 34
00:10:00 1 770 32
00:15:00 94 772 47
00:20:00 1 782 31
00:25:00 1 776 37
00:30:00 1 745 24
00:35:00 1 782 40
00:40:00 1 755 37
00:45:00 1 865 34
00:50:00 1 765 26
00:55:00 1 781 36
01:00:00 1 753 22
01:05:00 1 771 24
01:10:00 3 821 42
01:15:00 87 753 32
01:20:00 2 785 42
01:25:00 2 813 49
01:30:00 2 836 67
01:35:01 3 870 74
01:40:00 1 794 38
01:45:00 1 756 32
01:50:00 2 817 48
01:55:00 5 1238 50
02:00:00 1 750 20
02:05:00 1 775 24
02:10:00 1 741 22
02:15:00 99 743 21
02:20:00 2 740 26
02:25:00 1 762 24
02:30:00 1 731 20
02:35:00 6 941 51
02:40:00 9 1680 139
02:45:00 4 1006 222
02:50:00 8 1000 144
02:55:00 3 828 58
03:00:00 2 793 38
03:05:00 1 771 22
03:10:00 1 763 24
03:15:00 110 756 21
03:20:00 1 769 28
03:25:00 4 748 26
03:30:00 1 740 20
03:35:00 1 758 23
03:40:00 2 823 41
03:45:00 1 771 22
03:50:00 5 825 47
03:55:00 1 772 24
04:00:00 1 724 20
04:05:00 1 774 24
04:10:00 1 764 25
04:15:00 100 421 25
04:20:00 1 377 31
04:25:00 1 393 34
04:30:00 1 229 13
04:35:00 1 285 29
04:40:00 1 212 18
05:05:02 102 64 99
05:10:00 2 596 47
05:15:00 111 674 58
05:20:00 3 883 45
05:25:00 2 793 40
05:30:00 1 743 37
05:35:00 1 750 43
05:40:00 1 798 44
05:45:00 5 781 48
05:50:00 1 760 39
05:55:00 1 768 36
06:00:00 1 726 37
06:05:00 1 750 38
06:10:00 1 760 40
06:15:00 97 738 37
06:20:00 2 757 40
06:25:00 1 716 36
06:30:00 1 752 37
06:35:00 1 740 37
06:40:00 1 768 39
06:45:00 1 727 42
06:50:00 1 758 41
06:55:00 1 739 36
07:00:00 1 744 36
07:05:00 1 771 43
07:10:00 1 756 40
07:15:00 64 726 39
07:20:00 1 772 41
07:25:00 1 794 41
07:30:00 1 779 38
07:35:00 1 787 38
07:40:00 1 773 40
07:45:00 1 785 35
07:50:00 1 802 39
07:55:00 1 791 37
08:00:00 1 809 37
08:05:01 1 837 43
08:10:00 3 931 56
08:15:00 72 851 37
08:20:00 2 867 42
08:25:00 1 825 40
08:30:00 1 756 39
08:35:00 1 762 45
08:40:00 1 767 41
08:45:00 1 719 35
08:50:00 1 757 40
08:55:00 1 752 38
09:00:00 3 752 40
09:05:00 1 806 46
09:10:00 1 764 45
09:15:00 84 767 37
09:20:00 1 781 43
09:25:00 1 733 38
09:30:00 1 761 38
09:35:00 1 773 40
09:40:00 1 790 43
09:45:00 1 761 36
09:50:01 1 790 42
09:55:00 1 778 39
10:00:00 1 835 45
10:05:00 1 792 40
10:10:00 1 821 46
10:15:00 72 781 43
10:20:00 1 814 41
10:25:00 1 824 41
10:30:00 1 782 37
10:35:00 1 800 40
10:40:00 1 802 43
10:45:00 1 778 36
10:50:00 1 807 42
10:55:00 1 802 40
11:00:00 1 813 39
11:05:00 1 804 42
11:10:00 1 850 49
11:15:00 70 868 42
11:20:00 2 907 45
11:25:00 1 836 40
11:30:00 1 848 41
11:35:00 1 824 41
11:40:00 1 836 44

Average 102 65 99

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.