HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix F SQLUtil

MOVELOG

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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.
Feedback to webmaster