Re: Incremental Archive performance issue......

"Five Cats" <cats_spam@[127.0.0.1]> wrote in message news:Hc7W+WA3NmeAFwKT@[127.0.0.1]... > In message <c56p0h$cfc$1@terabinaries.xmission.com>, Alexey Sonkin > <alexeis@grandvirtual.com> writes > > > >For L1 archive, the backup speed is mostly limited by the > >disk array throughput: as I've already mentioned, Informix > >must read the entire database (like in L0 archive) > > Surely this depends on some extent as to how much of the database has > actually changed since the last L0 archive? And how, pray, is the Informix engine to know if a page has changed since the last level 0 archive????

Neil Truby wrote: > > "Five Cats" <cats_spam@[127.0.0.1]> wrote in message > news:Hc7W+WA3NmeAFwKT@[127.0.0.1]... > > In message <c56p0h$cfc$1@terabinaries.xmission.com>, Alexey Sonkin > > <alexeis@grandvirtual.com> writes > > > > > > >For L1 archive, the backup speed is mostly limited by the > > >disk array throughput: as I've already mentioned, Informix > > >must read the entire database (like in L0 archive) > > > > Surely this depends on some extent as to how much of the database has > > actually changed since the last L0 archive? > > And how, pray, is the Informix engine to know if a page has changed since > the last level 0 archive???? onstat -g arc oncheck -pr are your friends. The rest is to compare page timestamps with these entries in the reserved pages. dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe