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