2. Using Ingres Commands : relocatedb Command—Move a Location to a New Location : relocatedb Example: Relocate Checkpoint Files
 
Share this page                  
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.