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 (see page Create Unload Directory).
2. [Each DB including Ingres Star DDBs] Run Unloaddb (see page 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 (see page Check for Obsolete Users).
4. [Each DB] Edit the Unloaddb Output (see page Edit the Unloaddb Output).
5. [Each DB including iidbdb] (Optional) Checkpoint the Database (see page (Optional) Checkpoint the Database).
6. Disable User Access (see page Disable User Access).
7. Shut Down Ingres and Back Up System (see page Shut Down Ingres and Back Up System).
8. [Each DB] (Optional) Print Optimizer Statistics (see page (Optional) Print Optimizer Statistics).
9. [Each DB] Remove Non-table Objects (see page Remove Non-table Objects).
10. [Each DB] Record Database Information (see page Record Database Information).
11. Clean iidbdb Database (see page Clean iidbdb Database).
12. [Each DB including iidbdb] Checkpoint and Turn Off Journaling (see page Checkpoint and Turn Off Journaling).
13. Record Ingres Configuration (see page Record Ingres Configuration).
14. Shut Down Ingres (see page Shut Down Ingres).
15. Disable Ingres Startup (see page Disable Ingres Startup).
16. Preserve Site Modifications (see page Preserve Site Modifications)
17. Fix Logins (see page Fix Logins).
18. Save Ingres Settings (see page Save Ingres Settings).
19. Clean Up Ingres 6.4 (see page Clean Up Ingres 6.4).
20. Create Work Location (see page Create Work Location).
21. Install Ingres (see page Install Ingres).
22. Create imadb Database (see page Create imadb Database).
23. Restore Site Modifications (see page Restore Site Modifications).
24. Start Ingres (see page Start Ingres).
25. Run Upgradedb Utility (see page Run Upgradedb Utility).
26. Configure Ingres (see page Configure Ingres).
27. Set Up Ingres Net (see page Set Up Ingres Net).
28. [Each DB] Recreate Objects (see page Recreate Objects).
29. [Each DB] Reapply Storage Structures (see page Reapply Storage Structures).
30. [Each DB] Reapply Optimizer Statistics (see page Reapply Optimizer Statistics).
31. [Each DB including iidbdb] Checkpoint the Database (see page Checkpoint the Database).
32. 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.