Migrating the application database

You can use your existing TRIRIGA application database at its current location or prepare a new database and move the TRIRIGA application database. You need the database credentials for when you deploy and activate Maximo® Real Estate and Facilities.

Before you begin

Important: For the IBM® Db2® database only, a known limitation exists where you must keep the same schema name and database username as the TRIRIGA database or the migration fails. If you want to change the Db2 schema name or username, contact IBM Support.

For more information about the database options in Maximo Real Estate and Facilities, see Preparing your Maximo Real Estate and Facilities database.

The TRIRIGA system user is required for the database migration and must be part of the admin group. After the migration, the system user becomes a required internal Maximo Real Estate and Facilities user that is accessed only by application processes. In Maximo Real Estate and Facilities, administrators must no longer log in as the system user. The system user is not migrated to IBM Maximo Real Estate and Facilities. Administrators must create Maximo Application Suite users and assign them administrator privileges in Maximo Real Estate and Facilities administration, see Administering Maximo Real Estate and Facilities users.

Note: If you want to prevent workflows from being executed on both systems before the migration cutover from the old system to the new, truncate the wf_event table.

Procedure

  1. Log in to IBM TRIRIGA® or IBM TRIRIGA Application Suite and ensure that the TRIRIGA system user exists and belongs to the admin group.
  2. Optional: Move the TRIRIGA database.
    1. Prepare a new database for Maximo Real Estate and Facilities.
    2. Do a full backup of the TRIRIGA application database from the source environment with reference to your database vendor documentation.
    3. Restore the TRIRIGA application database into the prepared Maximo Real Estate and Facilities database with reference to your database vendor documentation.
  3. Clean up the database by purging the data from the AGENT_REGISTRY and AGENT_STARTUP tables.
    1. Ensure that the application database is no longer used by TRIRIGA and is not yet connected to Maximo Real Estate and Facilities.
    2. For IBM Db2, Oracle Database, or Microsoft SQL Server, enter the following commands to purge the data from AGENT_REGISTRY and AGENT_STARTUP tables. 
      TRUNCATE TABLE <schema>.AGENT_STARTUP;
TRUNCATE TABLE <schema>.AGENT_REGISTRY;
DELETE FROM <schema>.ENVIRONMENT_PROPERTIES where ENVIRONMENT= 'platform.class.upgrade' and PROPERTY = 'lastRun';
DELETE FROM <schema>.ENVIRONMENT_PROPERTIES where PROPERTY='com.tririga.util.startup.upgrade.AgentManagementUpgrade' and ENVIRONMENT='ibs.startup.upgrade';

      For Oracle Database, the schema name is typically the same as the username.

  4. Note the database credentials for when you deploy and activate Maximo Real Estate and Facilities.