BEGIN ARCHIVE

The BEGIN ARCHIVE statement in conjunction with the COMMIT ARCHIVE statement starts a new archive log file before a static backup is done to a DBEnvironment. However, this method is no longer recommended. The recommended approach to initiate archive logging and dynamic backup is to use the SQLUtil STOREONLINE command.

Scope

ISQL or Application Programs

SQL Syntax

BEGIN ARCHIVE

Description

Use of the BEGIN ARCHIVE statement is no longer recommended. 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.