• 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 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 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
      • Ingres Monitoring Tools and Scripts
      • Third Party Products Used
      • Checkpoint Template Changes
      • Checkpoint and Rollforward Changes
      • Shared Library Search Path (UNIX)
      • UNIX 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 Ingres and Back Up System
      • Clean the Database
      • Record Database Information
      • Checkpoint and Turn Off Journaling
      • Shut Down Ingres
      • Preserve Site Modifications
        • Commonly Customized Files
        • Preserve Necessary Files
        • Visual DBA Configurations
      • (Optional) Delete Install Directory and Move Bin, Lib, Utility Directories (UNIX)
      • Install Ingres
        • How You Upgrade to Older Versions That Require a Patch
      • Create imadb Database
      • Restore Site Modifications
        • Carry Forward Checkpoint Template Modifications
      • Start Ingres
      • Run Upgradedb Utility
      • Review 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 (UNIX)
      • Install Ingres
        • How You Upgrade to Older Versions That Require a Patch
      • Create imadb Database
      • Restore Site Modifications
      • Review Ingres Configuration
      • Set Up Ingres Net
      • Start 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
  • Considerations for OpenVMS
    • In This Chapter
    • OpenVMS Requirements
    • Considerations When Installing Ingres on OpenVMS
      • Mount the CD
      • Run VMSINSTAL
      • Known Installation Issues
    • How to Install Ingres for OpenVMS Clusters
    • Schema Checking
    • Application Rebuilding
      • Modifications Required For C Applications
      • Modifications Required For COBOL Applications
  • A. Features Introduced in Ingres 11.0
    • IngresConnect
    • Actian Enterprise Monitoring Appliance
    • DBMS Server Enhancements
    • Connectivity Enhancements
  • B. Features Introduced in Ingres 10.2
    • DBMS Server Enhancements
      • Ingres Geospatial Enhancements
      • IPV4 and IPV6 Data Types and Functions
      • DBMS Authentication
      • Per-query Parallelism Level
      • Window Functions
      • ROLLUP, CUBE, and GROUPING SETS
      • Inline BLOBs
      • New SQL Functions
      • Miscellaneous SQL Enhancements
      • Command Enhancements
      • Expanded User Names
    • Connectivity Enhancements
      • Secure Communications Encryption with AES
      • Obsolete Network Protocol Drivers Removed
        • Network Protocol Drivers Removed
        • Network Protocol Drivers Supported
    • Supportability Enhancements
  • C. Features Introduced in Ingres 10S
    • Actian Director
    • DBMS Server Enhancements
      • Geospatial Data Types and Functions
      • Common Table Expressions
      • Mulitiple-row INSERT
      • SQL Functions
      • Command Enhancements
      • Terminal Monitor Commands
      • New Location for Logs (Windows)
      • Log File Names Can Include Process ID and Date
      • II_DATE_FORMAT Settings ISO4T and ISO4TC
      • UCS_BASIC Collation for Columns
      • SET SESSION COLLATION
      • Default Configuration for Transactional System
    • Connectivity Enhancements
      • ODBC Batch Queries
      • JDBC getGeneratedKeys Enhancement
      • Ingres .NET Data Provider Enhancements
    • Supportability Enhancements
      • Unicode-enabled Database by Default
      • Portable UTF-8-encoded Copydb and Unloaddb
      • Date Format with Space Delimiter
      • DROP TABLE IF EXISTS
      • SET HASHAGG and SET HASHJOIN
      • Logging System Statistics Enhancement
      • Identification of Long Running Queries
      • Miscellaneous Enhancements
  • D. Features Introduced in Ingres 10.0
    • DBMS Server Enhancements
      • Ingres for 64-bit Windows
      • Multiversion Concurrency Control (MVCC)
      • Scalar Subqueries
      • Data at Rest Encryption
      • Long Identifiers
      • Renaming Tables and Columns
      • Bulk Loading Improvements
      • Batch Query Execution
      • BOOLEAN Data Type
      • New SQL Functions
      • Terminal Monitor Silent Mode
      • Daitch-Mokotoff Soundex Function
      • Check Digit Functions
      • Recovery Server Error Handling
      • Hash Join and Hash Aggregation Improvements
      • Query Execution Improvements Related to Partitioned Tables
      • Direct I/O Improvements (UNIX)
      • File Allocation Improvements (UNIX)
      • Standard Compression Performance Improvements
      • Miscellaneous Changes
    • Connectivity Enhancements
      • JDBC 4.0 Support
      • 64-bit ODBC Driver
      • ODBC Driver Names
      • IngresType.IngresDate Parameter Type in .NET Data Provider
      • Named Parameters in Parameterized Queries in .NET Data Provider
      • Positional Parameter Support in Drivers
      • TCP/IP for Local Communications on Windows
      • Performance Improvements to Communications Protocol Drivers on Windows
    • Supportability Enhancements
      • Process ID (PID) for GCF Servers Displayed in iimonitor
      • OpenAPI Writing of DBMS Trace Messages to File
    • Usability Enhancements
      • Improved Visual Tools Dialogs
      • Terminal Monitor Usability Enhancements

Upgrade Guide

Terminal Monitor Usability Enhancements