ALLBASE/SQL Reference Manual (36216-90216)

322 Chapter10
SQL Statements A - D
COMMIT ARCHIVE
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.