Ingres 11.0 | relocatedb Example: Relocate Dump Files

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

Was this helpful?

relocatedb Example: Relocate Dump Files

The following command relocates the dump location for the empdata database to newdump:

relocatedb empdata -new_dump_location=newdump

This command example does the following:

• Performs an update to the iidbdb: update iidatabase.dmpdev=’newdump’ where name=’empdata’. (This can be verified by connecting to the iidbdb database and doing a select from iidatabase where name=’empdata’.)

• Updates the dump location in the configuration file. (This can be verified by examining the output of the infodb empdata command.)

• Copies dump files from the old dump location to the new dump location.

• Deletes dump files from the old dump location.

Last modified date: 01/30/2023