A. Upgrading from Ingres 6.4 : How You Upgrade from Ingres 6.4 Using Unload/Reload
 
Share this page                  
How You Upgrade from Ingres 6.4 Using Unload/Reload
To upgrade from Ingres 6.4 using the unload/reload procedure, follow this process.
Note:  In this procedure, the notation [Each DB] means: “For each database, not including the iidbdb, 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. [Each DB including iidbdb] (Optional) Checkpoint the Database.
5. Disable User Access.
6. Shut Down Ingres and Back Up System.
7. [Each DB] Unload the Database.
8. [Each DB] (Optional) Print Optimizer Statistics.
9. [Each DB] Record Database Information.
10. Record Database Privileges.
11. Save Users, Groups, and Roles.
12. [Each DB] Destroy the Database.
13. Clean iidbdb Database.
14. Record Ingres Configuration.
15. Shut Down Ingres.
16. Disable Ingres Startup.
17. Preserve Site Modifications.
18. Fix Logins.
19. Save Ingres Settings.
20. Clean Up Ingres 6.4.
21. Create Work Location.
22. Install Ingres.
23. Create imadb Database.
24. Restore Site Modifications.
25. Configure Ingres.
26. Set Up Ingres Net.
27. Start Ingres.
28. Recreate Users, Groups, and Roles.
29. Recreate Locations.
30. [Each DB] Recreate the Database.
31. [Each DB] Extend the Database.
32. Recreate Database Privileges.
33. [Each DB] Fix FE Reload Script.
34. [Each DB] Reload the Database.
35. [Each DB] Upgrade Front-End Catalogs.
36. [Each DB] Reapply Optimizer Statistics.
37. [Each DB including iidbdb] Checkpoint the Database.
38. Install Upgraded Applications.
The sections that follow provide details on steps that differ from those described previously in this guide.