Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home
 ALLBASE/SQL Reference Manual: HP 3000 MPE/iX Computer Systems > Chapter 10 SQL Statements

BEGIN ARCHIVE
» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

If you do not have TURBO STORE and must do a static backup of your DBEnvironment, you can use the BEGIN ARCHIVE statement in conjunction with and immediately prior to the COMMIT ARCHIVE statement to start a new archive log file before a DBEnvironment is backed up. However, if you have TURBO STORE, the recommended approach to initiate archive logging is to use the SQLUtil STOREONLINE command, or to use the ARCHIVE option with the START DBE NEWLOG statement.

Scope

ISQL or Application Programs

SQL Syntax

BEGIN ARCHIVE

Description

  • You can turn archive mode off only by using the START DBE NEWLOG statement.

  • A backup copy of a DBEnvironment and an archive log file can be used for rollforward recovery when database files are physically damaged. In this type of recovery, you load a backup copy of the DBEnvironment, then issue the SQLUtil SETUPRECOVERY, RECOVERLOG, and ENDRECOVERY commands. You may also need to use RESCUELOG.

  • Use the following method to create a new archive log and a static backup of the DBEnvironment:

    • Issue the BEGIN ARCHIVE statement, then the COMMIT ARCHIVE statement, to write an archive record in the rollforward log. The archive record indicates the point from which rollforward recovery can begin.

    • Use the SQLUtil STORE command to make a static backup copy of the DBEnvironment. The DBEnvironment must be stopped and remain stopped while you are making the static backup copy if you are using STORE. This procedure does not turn the archive flag in the DBECon file on or off. You cannot use STORE from an application program, since it is an SQLUtil command.

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.

Example

     A single-user DBE session is established.  



   START DBE 'PartsDBE.SomeGrp.SomeAcct'
NOTE: Always use these two statements together in sequence. 
   BEGIN ARCHIVE

   COMMIT ARCHIVE

ALLBASE/SQL creates an archive record.

The DBEnvironment is shut down. Then the SQLUtil STORE command is used to make an archival copy of the DBEnvironment.

   STOP DBE


BEGIN
  		 


BEGIN DECLARE SECTION  
Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© Hewlett-Packard Development Company, L.P.