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