Home
Migrating and upgrading
You can upgrade to the 14.10 release of HCL Informix® or migrate from other database servers to Informix. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix database server can affect upgrading from a previous release.
Migrating Informix® database systems
The Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
Migration to and reversion from 14.10
Preparing for migration to Version 14.10
Before you install the new version of Informix®, you must prepare the database server environment for migration by performing specified pre-migration tasks. If you are also migrating from 32-bit to 64-Bit database servers, you must perform additional tasks.
Migrating from 32-bit to 64-bit database servers
If you are migrating from a 32-bit version of Informix® to a 64-bit version of Informix or reverting from a 64-bit version of Informix, you might need to follow additional steps to update certain internal tables.

Migrating and upgrading
You can upgrade to the 14.10 release of HCL Informix® or migrate from other database servers to Informix. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix database server can affect upgrading from a previous release.
- Migrating Informix® database systems
  The Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
  - Overview of migration
  - Migration to and reversion from 14.10
    - Preparing for migration to Version 14.10
      Before you install the new version of Informix®, you must prepare the database server environment for migration by performing specified pre-migration tasks. If you are also migrating from 32-bit to 64-Bit database servers, you must perform additional tasks.
      - Preparing for migration
        Preparing for migration includes gathering information about and backing up your data, so that you can reinstall the previous version of the server and restore your data if you have a migration problem. Preparing for migration is crucial for successful migration.
      - Pre-migration checklist of diagnostic information
        Before you migrate to a newer version of Informix®, gather diagnostic information, especially if you have large, complex applications. This information will be useful to verify database server behavior after migration. This information will also be useful if you need help from Software Support.
      - Migrating from 32-bit to 64-bit database servers
        If you are migrating from a 32-bit version of Informix® to a 64-bit version of Informix or reverting from a 64-bit version of Informix, you might need to follow additional steps to update certain internal tables.
    - Enterprise Replication and migration
      You must coordinate the migration of all servers that are involved in data replication.
    - High-availability cluster migration
      You must coordinate the migration and reversion of all servers that are involved in high-availability clusters. You can use a rolling upgrade in some cases to update servers while the cluster is online, with minimal interruption to client applications. Otherwise, you must schedule cluster downtime to upgrade the servers. A cluster must be offline to reverse an upgrade or revert to an earlier release.
    - Migrating to Informix® 14.10
      When you migrate to a new version of Informix®, you must complete required migration and post-migration tasks.
    - Reverting from Informix® Version 14.10
      You can revert to the version of the database server from which you migrated. When you run the reversion utility, you specify the target server for reversion and then Informix® checks your database. If necessary, Informix might tell you to drop new objects, before automatically converting your data into the target server.
  - Migration of data between database servers
  - Data migration utilities

Migrating from 32-bit to 64-bit database servers

If you are migrating from a 32-bit version of Informix® to a 64-bit version of Informix® or reverting from a 64-bit version of Informix®, you might need to follow additional steps to update certain internal tables.

These steps are documented in the platform-specific machine notes that are provided with your database server.

For 32- to 64-bit migrations, change SHMBASE and STACKSIZE according to the onconfig.std configuration file for the new version.

All UDRs and DataBlade® modules that were built in 32-bit mode must be recompiled in 64-bit mode because they will not work with the 64-bit database server. If you have any UDRs that were developed in 32-bit mode, make sure that proper size and alignment of the data structures are used to work correctly on a 64-bit computer after recompiling in 64-bit mode. For more information, refer to the machine notes.

Migrating from 32-bit to 64-bit with collection types that use the SMALLINT data type

If you are moving your database from a 32-bit computer to a 64-bit computer and your database contains collection types that use the SMALLINT data type, you must take extra steps to prevent memory corruption. Collection types are the ROW, LIST, SET, and MULTISET data types. This restriction applies if you are upgrading from an older version of Informix® on 32-bit to the current version of Informix® on 64-bit, or if you are moving from 32-bit to 64-bit on the current version of Informix®.

To migrate a database with SMALLINT collection types from 32-bit to 64-bit, use one of the following methods:

Export and import the data.
1. Export the data from the 32-bit computer.
2. Import the data onto the 64-bit computer.
Drop and recreate specific collection types and database objects.
1. Drop the collection types that use the SMALLINT data type and all other database objects that reference them (such as tables, columns, SPL routines, triggers, indexes, and so on).
2. Recreate the collections types and all the other necessary database objects.