COMMIT ARCHIVE

The COMMIT ARCHIVE statement in conjunction with the BEGIN 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 do a dynamic backup is to use the SQLUtil STOREONLINE command.

Scope

ISQL or Application Programs

SQL Syntax

COMMIT ARCHIVE

Description

• Use of the COMMIT 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.