HP 3000 Manuals

MOVELOG [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation


ALLBASE/SQL Database Administration Guide

MOVELOG 

Moves a log file from one location to another, and lets you specify a new
name.

Scope 

SQLUtil Only

SQLUtil Syntax 

>> MOVELOG  DBEnvironment Name:  DBEnvironmentName  Current Log File

Name:  CurrentFileName  Current Device:  CurrentDeviceClass  New Device
(opt):  NewDeviceNumber  New Log File Name:  NewLogFileName 

Parameters 

DBEnvironmentName       is the name of the DBEnvironment associated with
                        the file you are changing.

CurrentFileName         is the name of the log file that is to be moved.

CurrentDeviceNumber     is the device number of the device on which the
                        file currently resides.  This value is displayed
                        by MOVELOG.

NewDeviceNumber         is the device number of the device to which the
                        log file should be moved.  Use the MPE/iX SHOWDEV
                        command to display a list of available devices.

NewLogFileName          is the new name for the log file.  This must be
                        in the same account as the DBECon file.

Description 

   *   The MOVELOG command first displays the current device class of the
       device on which the log file resides, then it prompts for a new
       device number.  The file is moved to the device with the number
       the user specifies.  Use the MPE/iX LISTF,3 command for the
       specified log file to display both the current device class name
       and the current device number.

   *   The MOVELOG command can be used to change a log file's name and
       group, but it cannot be used to change a log file's account, which
       must be the same as the account of the DBECon file.

   *   The MOVELOG command can only be executed when the DBEnvironment is
       not in use.

Authorization 

You must either be the DBECreator or have SM capability to use this
command.

Example 

     >> movelog 
     DBEnvironment Name:  PartsDBE.SomeGrp.SomeAcct 
     Current Log File Name: lgn1 
     Current Device: DISC
     New Device (opt):  2 
     New Log File Name: lgn2 

     File moved.



MPE/iX 5.5 Documentation