Ingres 11.0 | relocatedb Example: Relocate Checkpoint Files

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

Was this helpful?

relocatedb Example: Relocate Checkpoint Files

The following command relocates the checkpoint location for the empdata database to newckp:

relocatedb empdata -new_ckp_location=newckp

This command example does the following:

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

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

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

• Deletes checkpoint files from the old checkpoint location.

Last modified date: 01/30/2023