HP 3000 Manuals HP 3000 Manuals
BEGIN ARCHIVE
If you do not have TURBO STORE and must do a static backup of your
DBEnvironment, you can use the BEGIN ARCHIVE statement in conjunction
with and immediately prior to the COMMIT ARCHIVE statement to start a new
archive log file before a DBEnvironment is backed up. However, if you
have TURBO STORE, the recommended approach to initiate archive logging is
to use the SQLUtil STOREONLINE command, or to use the ARCHIVE option with
the START DBE NEWLOG statement.
Scope
ISQL or Application Programs
SQL Syntax
BEGIN ARCHIVE
Description
* You can turn archive mode off only by using the START DBE NEWLOG
statement.
* A backup copy of a DBEnvironment and an archive log file can be
used for rollforward recovery when database files are physically
damaged. In this type of recovery, you load a backup copy of the
DBEnvironment, then issue the SQLUtil SETUPRECOVERY, RECOVERLOG,
and ENDRECOVERY commands. You may also need to use RESCUELOG.
* Use the following method to create a new archive log and a static
backup of the DBEnvironment:
* Issue the BEGIN ARCHIVE statement, then the COMMIT ARCHIVE
statement, to write an archive record in the rollforward
log. The archive record indicates the point from which
rollforward recovery can begin.
* Use the SQLUtil STORE command to make a static backup copy
of the DBEnvironment. The DBEnvironment must be stopped
and remain stopped while you are making the static backup
copy if you are using STORE. This procedure does not turn
the archive flag in the DBECon file on or off. You cannot
use STORE from an application program, since it is an
SQLUtil command.
Refer to the ALLBASE/SQL Database Administration Guide for detailed
backup and recovery procedures and recommended practices.
Authorization
You must have DBA authority to use this statement.
Example
A single-user DBE session is established.
START DBE 'PartsDBE.SomeGrp.SomeAcct'
NOTE Always use these two statements together in sequence.
BEGIN ARCHIVE
COMMIT ARCHIVE
ALLBASE/SQL creates an archive record.
The DBEnvironment is shut down. Then the SQLUtil STORE command is used
to make an archival copy of the DBEnvironment.
STOP DBE