HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

CHANGELOG 

Causes the DBEnvironment to change to the next log file.

Scope 

SQLUtil Only

SQLUtil Syntax 

>> CHANGELOG  DBEnvironment Name:  DBEnvironmentName  Maintenance Word:

MaintenanceWord  Change to a new log (y/n)?  {y[es]}
                                             {n[o] }
Parameters 

DBEnvironmentName       is the name of the DBEnvironment with which the
                        log files are associated.

MaintenanceWord         is the maintenance word.

Description 

   *   The CHANGELOG command causes ALLBASE/SQL to switch from the
       currently active log file to the next available log file, if one
       exists.

   *   Once you switch to the next available log file, you can back up
       the last used log file.

   *   The CHANGELOG command also displays the sequence numbers of the
       log file active just prior to the change as well as the log file
       active after the change.

Authorization 

You must be the DBECreator, have SM capability, or supply the correct
maintenance word to use this command.

Example 

     >> changelog 
     DBEnvironment Name:  PartsDBE 
     Maintenance Word:  MaintenanceWord 
     Change to new log (y/n)? y 

     Changed log from Sequence Number 2 to Sequence Number 3.

MPE/iX 5.5 Documentation