COMMIT ARCHIVE

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

COMMIT 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 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.

Example

A single-user DBE session is established.

   START DBE 'PartsDBE.SomeGrp.SomeAcct'



   ALLBASE/SQL creates an archive record.




	NOTE: Always use these two statements together in sequence.

   BEGIN ARCHIVE                

   COMMIT ARCHIVE            



   STOP DBE

The DBEnvironment is shut down. Then the SQLUtil STORE command is used to make an archival copy of the DBEnvironment.

COMMIT ARCHIVE

Technical documentation

» Table of Contents

» Index

Scope

SQL Syntax

Description

Authorization

Example