Using ontape when the server is up ?
Jack A asked whether running an ontape backup during working hours while the server is up is a problem. Madison Pruet, Art Kagel and Jonathan Leffler said online backups have been supported since OnLine 4.00 and the user impact is rarely significant, only slight slowdown. Umberto Quaia joked about needing a large temp dbspace. Answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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. Online backups have been supported for quite some time. "Jack A" <jacka8@excite.com> wrote in message news:2a56252b5fd6c265048ca0f4882b1a90@news.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. > >
On Fri, 29 Aug 2003 08:44:23 -0400, Jack A wrote: > 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
"Jack A" <jacka8@excite.com> wrote: > 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
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. > "Jack A" <jacka8@excite.com> wrote: >> 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. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/