• 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 Ingres 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 Ingres 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 Ingres 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 Ingres and Back Up System
    • Clean the Database
    • Record Database Information
    • Checkpoint and Turn Off Journaling
    • Shut Down Actian Ingres
    • 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 Ingres
      • How You Upgrade to Older Versions That Require a Patch
    • Create imadb Database
    • Restore Site Modifications
      • Carry Forward Checkpoint Template Modifications
    • Start Actian Ingres
    • Upgrading non-UTF-8 installations from Actian Ingres 11.2 to Actian Ingres 12.0 on Linux
    • Run Upgradedb Utility
      • Encrypted Database
    • Review Actian Ingres 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 Ingres
      • How You Upgrade to Older Versions That Require a Patch
    • Create imadb Database
    • Restore Site Modifications
    • Review Actian Ingres Configuration
    • Set Up Ingres Net
    • Start Actian Ingres
    • 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
• Features Introduced in Actian Ingres 11.0
  • X100 Engine
  • Actian Enterprise Monitoring Appliance
  • DBMS Server Enhancements
  • Connectivity Enhancements
• Features Introduced in Actian Ingres 11.1
  • DBMS Server Enhancements
  • Application Development Enhancement
  • Connectivity Enhancements
  • Reserved Keywords
• Features Introduced in Actian Ingres 11.2
  • JSON Support for X100 Tables
  • Scalar User-defined Functions (UDFs)
  • Workload Management
  • Reverse Strings
  • Wildcards in File Names for COPY VWLOAD
• Features Introduced in Actian Ingres 12.0
  • Add UDF Engines Startup to Ingstart Utility
  • Actian Ingres Spark Connector 3.0
  • Automatic Log Rotation
  • Ad hoc Auto Partitioning
  • Connectivity Enhancement
  • Cloud Checkpoint Locations
  • Containerization Deployment and Disaster Recovery
  • Containerized UDFs
  • Copydb -with_vwload
  • COPY VWLOAD Load Statistics and Results Statistics
  • Cryptographic Hash Functions for X100 Tables
  • Default Fill Factor for B-tree
  • ELEMENT and ELEMENT_COUNT
  • Extend Pattern-Matching Capabilities
  • Extend UDF Visibility
  • FIRST N AFTER M
  • Ingres Replicator Functionally Stabilized
  • IngresSync Tool
  • IPv and UUID Support in QBF
  • IS BOOLEAN Predicate
  • lengthb()
  • Performance Improvements
  • Protected_user privilege
  • Query Result Caching - Spill to Disk
  • Remote File System Support
  • Smart MinMax
  • Security Improvements
  • String Truncation Warn for X100
  • Support Rename Column on Partitioning Keys
  • Table Cloning
  • Table Synonym
  • Usability Improvements
  • UUID Support in the .Net Provider
  • UUID Support in the ODBC Driver
  • Workload Management 2.0

Planning the Upgrade

Features120.9.2.htm