Change an Installation Location with Unloading (UNIX)
Follow these steps in UNIX to change the value of II_SYSTEM, II_DATABASE, II_CHECKPOINT, II_JOURNAL II_DUMP, or II_WORK. “II_SYSTEM” is used as the example location being changed:
1. Unload each database. For details, see the Database Administrator Guide.
2. Remove the old installation files by removing everything under the old II_SYSTEM/ingres directory and any extended locations.
3. Set the value of II_SYSTEM and PATH to the desired new values, just as if you were installing Ingres for the first time.
4. Reinstall Ingres.
Follow the instructions in the Installation Guide for a new (not upgrade) installation.
As part of the installation procedure, the program prompts you for the new values of Ingres location variables II_DATABASE, II_CHECKPOINT, II_JOURNAL, II_DUMP, and II_WORK.
5. Recreate each of the databases. For details, see the Database Administrator Guide.
Use the createdb dbname command to recreate a database.
Reload each database by appropriately editing and running the reload.ing script.
6. Once you have reinstalled Ingres and recreated the databases in the new location, take new checkpoints of each of the databases. Checkpoints taken in old locations are no longer valid. For details, see the Database Administrator Guide.