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. [Each DB including the iidbdb] Clean the database.
4. [Each DB] Record database information.
5. [Each DB including the iidbdb] Checkpoint and turn off journaling.
6. Shut down Vector and perform an OS backup of the system.
7. Preserve site modifications.
8. (Optional) Delete install directory and move bin, lib, utility directories (Linux).
9. Install Vector.
10. Restore site modifications.
11. Verify Vector is starting (run ingstatus).
12. Run upgradedb utility.
13. Review Vector configuration.
14. (Optional) [Each DB] Reapply optimizer statistics.
15. [Each DB including the iidbdb] Checkpoint the database.
16. Install upgraded applications.
For details on each step, see the following sections.
Last modified date: 12/19/2024