How You Upgrade Using the Upgradedb Utility
Upgrading using upgradedb transforms your database in-place from the original version to the new, without requiring an unload and reload.
To upgrade using upgradedb, use the following process.
Note: In this process, the notation [Each DB] means: “For each database, not including the iidbdb (master database), become the DBA for that database and perform this step.” Do not include the iidbdb or Ingres Star distributed databases unless instructed. If using Ingres Star, remember to include the coordinator database in the list of databases.
1. Disable user access.
2. Disable Remote Command Server.
3. Shut down Ingres and back up system.
4. [Each DB including the iidbdb] Clean the database.
5. [Each DB] Record database information.
6. [Each DB including the iidbdb] Checkpoint and turn off journaling.
7. Shut down Ingres.
8. Preserve site modifications.
9. (Optional) Delete install directory and move bin, lib, utility directories (UNIX).
10. Install Ingres.
11. Create imadb database.
12. Restore site modifications.
13. Start Ingres.
14. Run upgradedb utility.
15. Review Ingres configuration.
16. (Optional) [Each DB] Reapply optimizer statistics.
17. [Each DB including the iidbdb] Checkpoint the database.
18. Install upgraded applications.
For details on each step, see the following sections.