Move Ingres Star Databases
For Ingres Star databases, use the same method as described above except that two databases must be unloaded and moved to the new installation:
1. Use unloaddb to unload the coordinator database (CDB) for the stardatabasename. This process unloads any locally stored tables.
unloaddb iistardatabasename
2. Use unloaddb on the distributed database (DDB). This process unloads registrations and distributed view definitions.
unloaddb stardatabasename/star
Note: When registering a table in Star, it is necessary to declare a “with NODE = node_name”. When moving to the new installation, it is necessary to either take across the existing Ingres Net vnode definitions or to manually create new ones that correspond to the existing vnode names; or having created new vnode names, edit the copy.in files.