A. Upgrading from Ingres 6.4 : How You Upgrade from Ingres 6.4 Using Upgradedb (Alternate)
 
Share this page                  
How You Upgrade from Ingres 6.4 Using Upgradedb (Alternate)
To upgrade from Ingres 6.4 using the alternate upgradedb 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.” Do not include the iidbdb or Ingres Star databases unless instructed. If using Ingres Star, remember to include the coordinator database in the list of databases.
1. [Each DB including Ingres Star DDBs] Create Unload Directory.
2. [Each DB including Ingres Star DDBs] Run Unloaddb.
Note:  You can omit Steps 2 through 4 if procedures already exist to recreate all database objects and storage structures. However, it will be necessary to make the appropriate changes to the oi_prep.sh script-see the step Remove Non-table Objects-for re-modifying all tables.
3. [Each DB including Ingres Star DDBs] Check for Obsolete Users.
4. [Each DB] Edit the Unloaddb Output.
5. [Each DB including iidbdb] (Optional) Checkpoint the Database.
6. Disable User Access.
7. Shut Down Ingres and Back Up System.
8. [Each DB] (Optional) Print Optimizer Statistics.
9. [Each DB] Remove Non-table Objects.
10. [Each DB] Record Database Information.
11. Clean iidbdb Database.
12. [Each DB including iidbdb] Checkpoint and Turn Off Journaling.
13. Record Ingres Configuration.
14. Shut Down Ingres.
15. Disable Ingres Startup.
16. Preserve Site Modifications.
17. Fix Logins.
18. Save Ingres Settings.
19. Clean Up Ingres 6.4.
20. Create Work Location.
21. Install Ingres.
22. Create imadb Database.
23. Restore Site Modifications.
24. Start Ingres.
25. Run Upgradedb Utility.
26. Configure Ingres.
27. Set Up Ingres Net.
28. [Each DB] Recreate Objects.
29. [Each DB] Reapply Storage Structures.
30. [Each DB] Reapply Optimizer Statistics.
31. [Each DB including iidbdb] Checkpoint the Database.
32. Install Upgraded Applications.
The sections that follow provide details on steps that differ from those described previously in this guide.