• Upgrade Guide
  • Planning the Upgrade
    • Purpose of This Guide
    • In This Chapter
    • Use of New Features
    • The Upgrade Plan
    • Upgrade Types
      • Upgradedb Method
      • Unload/Reload Method
    • Upgrade Method and Actian X Releases
      • From Releases Prior to Ingres 9.2
      • From Releases Ingres 9.2 and Newer
      • From Ingres 10.0 32-bit to Ingres 11 64-bit
      • From a 32-bit to a 64-bit Release
    • Release-specific Upgrade Issues
    • Required Installations for Upgrading
      • Possible Hardware Setups for Upgrading
    • How You Perform the Upgrade
    • How You Plan for Application Issues
      • The Test Plan for Applications
        • Categories of Application Functions
        • Application Debugging After the Upgrade
  • Creating a New Actian X Development Environment
    • Purpose of this Chapter
    • Platform-specific Examples in This Guide
    • How to Move an Existing Development Installation into the New Development Installation
    • Create the New Development Installation
    • How You Prepare Your Applications
      • Reserved Keyword Conflicts
      • Re-image ABF Applications
      • Use of the ANSIDATE Data Type
      • Migration to Unicode Applications
    • How You Load Databases and Applications into the New Installation
      • Create Users, Profiles, Groups, and Roles
      • Move Databases
      • Move Ingres Star Databases
      • The system_maintained Column Name
      • Compile Applications
    • How You Prepare for Development Installation Upgrade
      • Installation Back Up
      • Actian X Monitoring Tools and Scripts
      • Third Party Products Used
      • Checkpoint Template Changes
      • Checkpoint and Rollforward Changes
      • Shared Library Search Path (Linux)
      • Linux Kernel Parameters
    • Testing Applications and Procedures
      • Application Testing
      • Performance Testing
      • System Administrator Procedure Testing
    • How You Practice the Upgrade
  • Upgrading Using Upgradedb
    • In This Chapter
    • Ownership Assumptions for Running Upgradedb
    • How You Upgrade Using the Upgradedb Utility
      • Disable User Access
      • Disable Remote Command Server
      • Shut Down Actian X and Back Up System
      • Clean the Database
      • Record Database Information
      • Checkpoint and Turn Off Journaling
      • Shut Down Actian X
      • Preserve Site Modifications
        • Commonly Customized Files
        • Preserve Necessary Files
        • Visual DBA Configurations
      • (Optional) Delete Install Directory and Move Bin, Lib, Utility Directories (Linux)
      • Install Actian X
        • How You Upgrade to Older Versions That Require a Patch
      • Create imadb Database
      • Restore Site Modifications
        • Carry Forward Checkpoint Template Modifications
      • Start Actian X
      • Run Upgradedb Utility
      • Review Actian X Configuration
      • Checkpoint the Database
      • Install Upgraded Applications
  • Upgrading Using Unload/Reload
    • In This Chapter
    • Why Use Unload/Reload?
    • Variations of Unload/Reload Procedure
    • How You Perform an Upgrade Using Unload/Reload
      • Create Unload Directory
      • Run Unloaddb
      • Check for Obsolete Users
      • (Optional) Checkpoint the Database
      • Disable User Access
      • Disable Remote Command Server
      • Shut Down Ingres and Back Up System
      • Unload the Database
      • (Optional) Print Optimizer Statistics
      • Record Database Information
      • Record Database Privileges
      • Save Users, Groups, and Roles
      • Destroy the Database
      • Clean iidbdb Database
      • Disable Ingres Startup
      • Preserve Site Modifications
        • Visual DBA Configurations
      • (Optional) Delete Install Directory and Move Bin, Lib, Utility Directories (Linux)
      • Install Actian X
        • How You Upgrade to Older Versions That Require a Patch
      • Create imadb Database
      • Restore Site Modifications
      • Review Actian X Configuration
      • Set Up Ingres Net
      • Start Actian X
      • Recreate Users, Groups, and Roles
      • Recreate Locations
      • Recreate the Database
      • Extend the Database
      • Recreate Database Privileges
      • Fix FE Reload Script
      • Reload the Database
      • Upgrade Front-End Catalogs
      • Reapply Optimizer Statistics
      • Checkpoint the Database
      • Install Upgraded Applications
  • Troubleshooting Upgradedb
    • How to Avoid Upgradedb Problems
    • Typical Upgradedb Problems
    • Other Upgradedb Problems
  • A. Features Introduced in Actian X 11.0
    • X100 Engine
    • IngresConnect
    • Actian Enterprise Monitoring Appliance
    • DBMS Server Enhancements
    • Connectivity Enhancements
  • B. Features Introduced in Actian X 11.1
    • DBMS Server Enhancements
    • Application Development Enhancement
    • Connectivity Enhancements
    • Reserved Keywords

Upgrade Guide

Reserved Keywords