HPlogo ALLBASE/SQL Reference Manual > Chapter 10 SQL Statements A - D

COMMIT ARCHIVE

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

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.



CLOSE

COMMIT WORK