Database migration to Maximo IT

Edit online

The migration process for moving to Maximo IT includes the database deployment and then production deployment post successful testing. When moving to Maximo IT, you need to plan your database migration carefully.

The database migration process depends on:
  • Your current database system (MS SQL, Db2, or Oracle).
  • Where you want to host your database in the Maximo Application Suite (MAS).

Below is the series of steps you need to perform when migrating to Maximo IT in terms of database migration:

  1. Identify your Database system

    Check which database your setup is using:

    • MS SQL or Oracle: Contact the respective vendor for migration support.
    • Db2 (Windows Server): IBM Db2 Support can help with migration options.
  2. Choose where to host your database in MAS

    MAS provides two options for database hosting:

    Option 1: Keep the Database Outside the MAS Cluster (Recommended)

    • Supported for MS SQL, Db2, and Oracle.

    • Best for production environments as it optimizes hardware and reduces costs.

    • No migration is required. Users must ensure the MAS cluster can connect to their existing database.

    Option 2: Keep the Database Inside the MAS Cluster

    • Only supported for Db2.

    • Requires extra migration steps if moving from Windows to OpenShift/Linux.

    • No direct compatibility exists for moving a Db2 database from Windows to a Unix-based system. Manual migration using Db2 utilities is required.
  3. Final steps based on Database hosting
    • If keeping the database outside MAS: Ensure the MAS cluster can connect to your database. No further migration is needed.

    • If moving the database inside MAS: Work with IBM’s Db2 experts to perform the required migration steps.

Running updatedb utility through pod

The updatedb utility is a part of MAS Framework (MAF). You can run the updatedb utility through the Maxinst Pod. More details on the update utilities below:

For more information on updating Manage, see Updating IBM Maximo Manage.

For more information about how to run Maxinst in a MAS environment, see How to run MAXINST in a MAS environment.

For more information on Maximo Application Framework, see Maximo Application Framework Configuration application.