2. Using Ingres Commands : relocatedb Command--Move a Location to a New Location : relocatedb Example: Relocate Journal Files
 
Share this page                  
relocatedb Example: Relocate Journal Files
The following command relocates the journal location for the empdata database to newjnl:
relocatedb empdata -new_jnl_location=newjnl
This command example does the following:
Performs an update to the iidbdb: update iidatabase.jnldev=’newjnl’ where name=’empdata’. (This can be verified by connecting to the iidbdb database and doing a select from iidatabase where name=’empdata’.)
Updates the journal location in the configuration file. (This can be verified by examining the output of the infodb empdata command.)
Copies journal files from the old journal location to the new journal location.
Deletes journal files from the old journal location.