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 (see page Create Unload Directory).
2. [Each DB] Run Unloaddb (see page Run Unloaddb).
3. [Each DB] Check for Obsolete Users (see page Check for Obsolete Users).
4. [Each DB including iidbdb] (Optional) Checkpoint the Database (see page (Optional) Checkpoint the Database).
5. Disable User Access (see page Disable User Access).
6. Shut Down Ingres and Back Up System (see page Shut Down Ingres and Back Up System).
7. [Each DB] Unload the Database (see page Unload the Database).
8. [Each DB] (Optional) Print Optimizer Statistics (see page (Optional) Print Optimizer Statistics).
9. [Each DB] Record Database Information (see page Record Database Information).
10. Record Database Privileges (see page Record Database Privileges).
11. Save Users, Groups, and Roles (see page Save Users, Groups, and Roles).
12. [Each DB] Destroy the Database (see page Destroy the Database).
13. Clean iidbdb Database (see page Clean iidbdb Database).
14. Record Ingres Configuration (see page Record Ingres Configuration).
15. Shut Down Ingres (see page Shut Down Ingres).
16. Disable Ingres Startup (see page Disable Ingres Startup).
17. Preserve Site Modifications (see page Preserve Site Modifications).
18. Fix Logins (see page Fix Logins).
19. Save Ingres Settings (see page Save Ingres Settings).
20. Clean Up Ingres 6.4 (see page Clean Up Ingres 6.4).
21. Create Work Location (see page Create Work Location).
22. Install Ingres (see page Install Ingres).
23. Create imadb Database (see page Create imadb Database).
24. Restore Site Modifications (see page Restore Site Modifications).
25. Configure Ingres (see page Configure Ingres).
26. Set Up Ingres Net (see page Set Up Ingres Net).
27. Start Ingres (see page Start Ingres).
28. Recreate Users, Groups, and Roles (see page Recreate Users, Groups, and Roles).
29. Recreate Locations (see page Recreate Locations).
30. [Each DB] Recreate the Database (see page Recreate the Database).
31. [Each DB] Extend the Database (see page Extend the Database).
32. Recreate Database Privileges (see page Recreate Database Privileges).
33. [Each DB] Fix FE Reload Script (see page Fix FE Reload Script).
34. [Each DB] Reload the Database (see page Reload the Database).
35. [Each DB] Upgrade Front-End Catalogs (see page Upgrade Front-End Catalogs).
36. [Each DB] Reapply Optimizer Statistics (see page Reapply Optimizer Statistics).
37. [Each DB including iidbdb] Checkpoint the Database (see page Checkpoint the Database).
38. Install Upgraded Applications (see page Install Upgraded Applications).
The sections that follow provide details on steps that differ from those described previously in this guide.