MOVEFILE

Moves any DBEFile across devices.

Scope

SQLUtil Only

SQLUtil Syntax

>> MOVEFILE DBEnvironment Name: DBEnvironmentName Current File Name: CurrentFileName New File Name: NewFileName

Parameters

DBEnvironmentName: is the name of the DBEnvironment with which the file you are changing is associated. 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 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 file. This may be either an absolute pathname or a pathname relative to that of the DBECon file.

Description

The MOVEFILE command prompts for the file's current pathname and new pathname, and then moves the file to its new location. This lets you either rename a file or change directories in order to place the file on a different device. Your hpdb must be able to write to the new directory. To write to the new directory, set the file permissions of the directory where the DBEnvironment resides to 755, change the directory's ownership to hpdb, and set the group id to bin.
You can use MOVEFILE only with DBEFiles. To move log files, you must use the MOVELOG command. You cannot move a DBECon file with MOVEFILE.
The MOVEFILE command can only be executed when the DBEnvironment is not in use.

Authorization

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

Example

   >> movefile

   DBEnvironment Name:  ../sampledb/PartsDBE

   Current File Name:  PartsIdx1

   New File Name:  /mnt/allbase/PartsIdx1



   File moved.