Bonnie,

It is common practice with user logging to start a new log cycle with each
backup by stopping logging, resetting the log file counter back to 1, and
restart logging.

Be aware that with 7x24 backup in combination with user logging you don't
want to reset your log files back to 001 and start another log cycle as it
will hinder recovery. The backup products store the current log file and
date/time stamp in the root file. Resetting the log files back to 001 will
confuse DBRECOV. While you can override the traditional DBSTORE timestamp in
DBRECOV, you cannot override the current logfile number.

Theoretically you would not stop and restart the logging cycle each day
because that would require logging off all of your users, defeating the
purpose of the online backup. But often times when initially testing the
backup product the existing procedures are left in place and the online
backup feature is employed.

BTW, this is really a problem with DBRECOV and is not a slight against any
of the products or vendors that offer full online backup capability.

Doug.

Doug Werth                             Beechglen Development Inc.
[log in to unmask]                               Cincinnati, Ohio

----- Original Message -----
From: Bonnie Roman <[log in to unmask]>
To: <[log in to unmask]>
Sent: Thursday, February 17, 2000 4:24 PM
Subject: TurboStore Online w/database image logging


> Hello Masters of the MPE world,
>
> We're considering TurboStore/iX with 7x24 True online option for one of
our
> boxes. But we also use database image logging. Does anyone have experience
with
> this combination? Both positive and negative comments are welcome.
>
> We currently use Orbit but can't risk using their Zerodown time option
because
> they don't recommend it being used with database image logging due to
possible
> corruption.
>
>
> TIA
> Bonnie Roman
> HP3000 System Admin
> Quebecor World
> 630-285-6581