How You Perform an Upgrade Using Unload/Reload
A database unload/reload ensures a clean start with a fresh database.
To perform an upgrade using unload/reload, 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, cd to the unload directory for the database created in Step 1, and perform this step.” If using Ingres Star, include the coordinator database in the list of databases. Steps that apply to a particular upgrade type only (that is, in-place upgrade or clean install upgrade) are marked accordingly.
1. [Each DB including iidbdb] Create unload directory.
2. [Each DB] Run unloaddb.
3. [Each DB] Check for obsolete users.
4. (Optional) [Each DB Including iidbdb] Checkpoint the database.
5. Disable user access.
6. Disable Remote Command Server.
7. Shut down Ingres and back up system.
8. [Each DB] Unload the database.
9. (Optional) [Each DB] Print optimizer statistics.
10. [Each DB] Record database information.
11. Record database privileges.
12. Save users, groups, and roles.
13. [Each DB] Destroy the database.
14. Clean iidbdb database.
15. Shut down ingres.
16. Disable Ingres startup.
17. Preserve site modifications.
18. (Optional) Delete install directory and move bin, lib, utility directories (UNIX).
19. Install Ingres.
20. Create imadb database.
21. Restore site modifications.
22. Review Ingres configuration.
23. Set up Ingres Net.
24. Start Ingres.
25. Recreate users, groups, and roles.
26. Recreate locations.
27. [Each DB] Recreate the database.
28. [Each DB] Extend the database.
29. Recreate database privileges.
30. [Each DB] Fix FE reload script.
31. [Each DB] Reload the database.
32. [Each DB] Upgrade front-end catalogs.
33. [Each DB] Reapply optimizer statistics.
34. [Each DB] Checkpoint the database.
35. Install upgraded applications.
For details on these steps, see the following sections.