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.