Ingres 12.0 | relocatedb Example: Relocate Journal Files

Command Reference Guide > Command Reference Guide > Using Ingres Commands > relocatedb Command--Move a Location to a New Location > relocatedb Example: Relocate Journal Files

Was this helpful?

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.

Last modified date: 08/29/2024