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