HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 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.

Scope

SQLUtil Only

SQLUtil Syntax

>> MOVELOG DBEnvironment Name: DBEnvironmentName Current Log File Name: CurrentFileName New Log File Name: NewFileName

Parameters

DBEnvironmentName

is the name of the DBEnvironment associated with the file you are changing. The DBEnvironment name may be entered either as an absolute pathname or as a pathname relative to your current working directory.

CurrentFileName

is the current pathname of the log file to be moved. This may be either an absolute pathname or a pathname relative to that of the DBECon file of the DBEnvironment name you have entered.

NewFileName

is the new pathname for the log file. This may be either an absolute pathname or a pathname relative to that of the DBECon file.

Description

  • The MOVELOG command prompts for the current pathname and the new pathname of the file, and then changes the file to the new pathname. This lets you either rename a log file or change directories in order to place the log file on a different device. Your hpdb must be able to write to the new directory. This is accomplished by having the file permissions of the directory where the DBEnvironment resides set to mode 755, having the directory owned by hpdb, and having a group id of bin.

  • The DBEnvironment may not be in use while this command is executed.

Authorization

You must be the DBECreator or superuser to use this command.

Example

   >> movelog

   DBEnvironment Name:  ../sampledb/PartsDBE

   Maintenance Word:   Return 

   Current Log File Name: lgn1

   New Log File Name: /safe/lgn1



   File Moved.
Feedback to webmaster