If you do not have TURBO STORE and you must do a static backup, you can use
the COMMIT ARCHIVE statement following the BEGIN 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 |
 |
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 procedure 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.
If a procedure invoked by a rule executes a
COMMIT ARCHIVE statement, an error occurs.
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.