International Informix Users Group

	Informix News

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 Previous news items

End of Support Dates

IDS 11.10 - 30 Sep 2012 Subscribe to notifications

Home Member Area About IIUG Help

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

SAP Mix

RE: Informix data warehouses & onbar

Posted By: Darrell Murphy
Date: Monday, 7 June 2004, at 10:07 a.m.

In Response To: Informix data warehouses & onbar (NormaJean.Sebastian@tellabs.com)

We always do hot backups on our BW system and there's been no impact on the
users. Unfortunately, our BW system is probably not 'big' enough to give
you an all encompassing answer to put Oracle in its place. Database is
about 400 GB but 1/3 of that is staging data which our BW folks won't let go
of (supposed to be temporary holding place where BW takes imported data and
massages it for loading into the actual cubes). We only have 10 - 20 users
on there at any one time. So we don't stress it. But you can say under
Informix 9.30 our BW is up 24 hours a day. Its (hot) backup runs about
3:00 PM every day in parallel with daily users and data loads. The only
time BW is unavailable to users is an occasional Sunday when the DBA has it
for planned maintenance. We use onbar with HP Omniback on HP Unix servers
and a tape library with 4 drives. Our Unix admin has that piece so I'm not
sure how long it takes but it's under two hours - full backup every day.

Darrell Murphy
Burton Snowboards

-----Original Message-----
From: NormaJean.S.... [mailto:NormaJean.Sebastian@tellabs.com]
Sent: Friday, June 04, 2004 3:37 PM
To: sapmix@iiug.org
Subject: Informix data warehouses & onbar [356]

Hi,

I have not yet been fortunate enough to work on an Informix data
warehouse, I am wondering if Informix 7.31 and/or 9.40 perform as
admirably in a data warehouse environment as in an OLTP.

Specifically in terms of data backup in conjunction with transaction
processing.

Those of you with an Informix warehouse using onbar backups.... have
you seen dramatic i/o throughput problems impacting user performance
perhaps during data load times if the backup is running, etc?....
problems to the degree that you have had to come up with a unique backup
solution because Informix could not handle it?
I am seeking information as a curiosity (and potential fuel)... I
believe Informix would do just fine in such a scenario (if the server
itself is not thrashing,etc).

I have been told that we should not do "hot backups" of our SAP BW
system on Oracle because Oracle will not handle the load of a hot
backup, transaction logging, and a data load at the same time
efficiently. Granted, the hot backup window could be adjusted somewhat
around the data load time, but transaction logging on an oracle data
warehouse was more or less "poo pooed",
therefore... the DB comes down for cold backups. That just seems silly
to me.

thanks for the input.
Norma Jean

-----------------------------------------
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the
reader of this message is not the intended recipient, or an
employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any
reproduction, dissemination or distribution of this
communication is strictly prohibited. If you have received
this communication in error, please notify us immediately by
replying to the message and deleting it from your computer.

Thank you.
Tellabs
============================================================

------_=_NextPart_001_01C44C98.317752A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: Informix data warehouses & onbar [356] </TITLE>
</HEAD>
<BODY>

We always do hot backups on our BW system and there's =
been no impact on the users.  Unfortunately, our BW system is =
probably not 'big' enough to give you an all encompassing answer to put =
Oracle in its place.  Database is about 400 GB but 1/3 of that is =
staging data which our BW folks won't let go of (supposed to be =
temporary holding place where BW takes imported data and massages it =
for loading into the actual cubes).   We only have 10 - 20 =
users on there at any one time.  So we don't stress it.  But =
you can say under Informix  9.30 our BW is up 24 hours a =
day.  Its (hot) backup runs about 3:00 PM every day in parallel =
with daily users and data loads.  The only time BW is unavailable =
to users is an occasional Sunday when the DBA has it for planned =
maintenance.  We use onbar with HP Omniback on HP Unix servers and =
a tape library with 4 drives.  Our Unix admin has that piece so =
I'm not sure how long it takes but it's under two hours - full backup =
every day.

Darrell Murphy
 Burton Snowboards


-----Original Message-----
 From: NormaJean.S.... [<A =
HREF=3D"mailto:NormaJean.Sebastian@tellabs.com">mailto:NormaJean.Sebasti=
an@tellabs.com</A>]
 Sent: Friday, June 04, 2004 3:37 PM
 To: sapmix@iiug.org
 Subject: Informix data warehouses & onbar [356] =


 

Hi,


I have not yet been fortunate enough to work on an =
Informix data
 warehouse, I am wondering if Informix 7.31 and/or =
9.40 perform as
 admirably in a data warehouse environment as in an =
OLTP.


Specifically in terms of data backup in conjunction =
with transaction
 processing.


Those of you with an Informix warehouse using onbar =
backups....  have
 you seen dramatic i/o throughput problems impacting =
user performance
 perhaps during data load times if the backup is =
running, etc?....
 problems to the degree that you have had to come up =
with a unique backup
 solution because Informix could not handle it? =

 I am seeking information as a curiosity (and =
potential fuel)... I
 believe Informix would do just fine in such a =
scenario (if the server
 itself is not thrashing,etc).


I have been told that we should not do "hot =
backups" of our SAP BW
 system on Oracle because Oracle will not handle the =
load of a hot
 backup, transaction logging, and a data load at the =
same time
 efficiently.  Granted, the hot backup window =
could be adjusted somewhat
 around the data load time, but transaction logging =
on an oracle data
 warehouse was more or less "poo pooed", =

 therefore... the DB comes down for cold =
backups.  That just seems silly
 to me.


thanks for the input.
 Norma Jean

 
 
 

-----------------------------------------
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 The information contained in this message may be =
privileged 
 and confidential and protected from =
disclosure.  If the 
 reader of this message is not the intended =
recipient, or an 
 employee or agent responsible for delivering this =
message to 
 the intended recipient, you are hereby notified that =
any 
 reproduction, dissemination or distribution of this =

 communication is strictly prohibited. If you have =
received 
 this communication in error, please notify us =
immediately by 
 replying to the message and deleting it from your =
computer.


Thank you.
 Tellabs
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


</BODY>
</HTML>
------_=_NextPart_001_01C44C98.317752A0--

------=_NextPartTM-000-29fdabef-79ea-40c3-8551-bdde1b16fdbe--

Messages In This Thread

Informix data warehouses & onbar
NormaJean.Sebastian@tellabs.com -- Monday, 7 June 2004, at 10:07 a.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

SAP Mix is maintained by Administrator with WebBBS 5.12.