ALLBASE/SQL Reference Manual (36216-90216)

310 Chapter10
SQL Statements A - D
BEGIN ARCHIVE
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.