Using ontape when the server is up ?

#1

Is there any problem in backing up the instance during normal working hours
? I'd expect there to be some head movement on the disks which might slow
down some user operations, but that shouldnt be noticeable. I'd just like to
be sure about this though.

#2

No problem. Online backups have been supported for quite some time.

"Jack A" <jacka8 (AT) excite (DOT) com> wrote

Quote:

Is there any problem in backing up the instance during normal working
hours
? I'd expect there to be some head movement on the disks which might slow
down some user operations, but that shouldnt be noticeable. I'd just like
to
be sure about this though.

#3

On Fri, 29 Aug 2003 08:44:23 -0400, Jack A wrote:

Quote:

Is there any problem in backing up the instance during normal working hours ?
I'd expect there to be some head movement on the disks which might slow down
some user operations, but that shouldnt be noticeable. I'd just like to be
sure about this though.

No problem. The ability to archive the server while user activity is going on
is why Informix's server was originally called 'OnLine'. The effect on users
is rarely significant.

Art S. Kagel

#4

The product was even designed around online backups. As to the original
question, the performance hit would be equivalent to one or two extra users.

regards

Malcolm

----- Original Message -----
From: "Madison Pruet" <mpruet (AT) comcast (DOT) net>
To: <informix-list (AT) iiug (DOT) org>
Sent: Friday, August 29, 2003 2:00 PM
Subject: Re: Using ontape when the server is up ?

Quote:

No problem. Online backups have been supported for quite some time.

"Jack A" <jacka8 (AT) excite (DOT) com> wrote in message
news:2a56252b5fd6c265048ca0f4882b1a90 (AT) news (DOT) teranews.com...
Is there any problem in backing up the instance during normal working
hours
? I'd expect there to be some head movement on the disks which might
slow
down some user operations, but that shouldnt be noticeable. I'd just
like
to
be sure about this though.

sending to informix-list

#5

Jack A wrote:

Quote:

Is there any problem in backing up the instance during normal working hours
? I'd expect there to be some head movement on the disks which might slow
down some user operations, but that shouldnt be noticeable. I'd just like to
be sure about this though.

I agree with the others that the product was originally called OnLine
because it stays on-line 24x7, even during backups. However, you can
consider an archive to be a large batch job. It depends on what other
users are doing, and OLTP access will probably not notice. I have seen
problems, actually after hours, when an archive clashes with other batch
jobs, they took a huge hit in performance.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

Quote:

Mark D. Stock mailto:mdstock (AT) MydasSolutions (DOT) com |//////// /|
Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
+-----------------------------------+//// / ///|
|We value your comments, which have |/// / ////|
|been recorded and automatically |// / /////|
|emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list

#6

"Jack A" <jacka8 (AT) excite (DOT) com> wrote:

Quote:

Is there any problem in backing up the instance during normal
working hours
? I'd expect there to be some head movement on the disks which might
slow
down some user operations, but that shouldnt be noticeable. I'd just
like to
be sure about this though.

Just provide a temp dbspace large enough to hold
previous-image of modified pages... ;-)

Umberto Quaia

#7

Jonathan Leffler wrote:

Quote:

(why do
people think that running 3.5 hours or so a day, as in 24/7, is so
great? And 1WD wouldn't be as much fun as 4WD in a 4x4?)

Sixteen wheel drive? What a hoot!

#8

Jonathan Leffler wrote:

Quote:

Madison Pruet wrote:

No problem. Online backups have been supported for quite some time.

Meaning about 1989 (or 1988), when OnLine 4.00 was introduced. I
don't think Turbo 1.03.0n (the predecessor version) allowed online
backups, but I'd stand to be corrected by those who used it. The
reason OnLine was so named was because it could run 24x7 (why do
people think that running 3.5 hours or so a day, as in 24/7, is so
great? And 1WD wouldn't be as much fun as 4WD in a 4x4?) and still
have coherent backups performed. And there is the slight performance
degradation you referred to - but it should, usually, be slight.

I prefer my AWD car thanks. ;-)

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

Quote:

Mark D. Stock mailto:mdstock (AT) MydasSolutions (DOT) com |//////// /|
Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
+-----------------------------------+//// / ///|
|We value your comments, which have |/// / ////|
|been recorded and automatically |// / /////|
|emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list

#9

Should have been here for the Harley-Davidson 100th...migawd...the
noise...the power...the bare chested-women...

"Andrew Hamm" <ahamm (AT) mail (DOT) com> wrote

Quote:

Mark D. Stock wrote:

I prefer my AWD car thanks. ;-)

I prefer my RWD - phwoar - lurid power slides across 3 lanes of traffic
can't be beat for excitement

#10

--0-1682150453-1062792589=:92236
Content-Type: text/plain; charset=us-ascii

Impy - You should have been in Sturgis and surrounding area this year - same reason.

Rob

Impy <impy2101 (AT) yahoo (DOT) com> wrote:
Should have been here for the Harley-Davidson 100th...migawd...the
noise...the power...the bare chested-women...

"Andrew Hamm" wrote in message
news:bj9cbm$gkcne$1 (AT) ID-79573 (DOT) news.uni-berlin.de...

Quote:

Mark D. Stock wrote:

I prefer my AWD car thanks. ;-)

I prefer my RWD - phwoar - lurid power slides across 3 lanes of traffic
can't be beat for excitement

Rob Vorbroker Phone: 513/336-8695
Vorbroker Consulting, Inc. Fax: 513/336-6812
www.vorbroker.com robv (AT) vorbroker (DOT) com

---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
--0-1682150453-1062792589=:92236
Content-Type: text/html; charset=us-ascii

<DIV>Impy - You should have been in Sturgis and surrounding area this year - same reason.</DIV>
<DIV> </DIV>
<DIV>Rob<BR><BR><B><I>Impy <impy2101 (AT) yahoo (DOT) com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Should have been here for the Harley-Davidson 100th...migawd...the<BR>noise...the power...the bare chested-women...<BR><BR>"Andrew Hamm" <AHAMM (AT) MAIL (DOT) COM>wrote in message<BR>news:bj9cbm$gkcne$1 (AT) ID-79573 (DOT) news.uni-berlin.de...<BR>> Mark D. Stock wrote:<BR>> ><BR>> > I prefer my AWD car thanks. ;-)<BR>><BR>> I prefer my RWD - phwoar - lurid power slides across 3 lanes of traffic<BR>> can't be beat for excitement<BR>><BR>><BR><BR></BLOCKQUOTE><BR><BR>Rob Vorbroker Phone: 513/336-8695 <br>Vorbroker Consulting, Inc. Fax: 513/336-6812 <br>www.vorbroker.com robv (AT) vorbroker (DOT) com<p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo! SiteBuilder</a> - Free, easy-to-use web site design software
--0-1682150453-1062792589=:92236--
sending to informix-list