Migrating from V9.1 to V11.4

To migrate to IBM® InfoSphere® Master Data Management Collaboration Server Version 11.4 from IBM InfoSphere Master Data Management Server for Product Information Management Version 9.1.0, you must run the appropriate migration script.

Before you begin

Before you can migrate from InfoSphere MDM Server for PIM V9.1.0 to InfoSphere MDM Collaboration Server V11.4, you must ensure that you are specifically using Fix Pack 2 or later fix packs for V9.1.0. If you are using V9.1.0 with any other level of fix pack, you must migrate to V9.1.0 Fix Pack 2 or later fix packs. Complete the instructions in the appropriate release notes.

You must also ensure that all XML-related table spaces are created as described in the installation guide. Ensure that the InfoSphere MDM Collaboration Server database user has appropriate privileges to use the new table spaces.

You can configure the error log file location by modifying the _ERROR_LOGS variable in the migrateFrom910.sh migration script. This variable is set to $TOP/logs/errfile.log by default.

If you are using custom table space names instead of the default USERS or INDX, you must manually modify the table space names in create_pimdb.sh and create_pimdb_for_zLinux.sh in the folder $TOP/bin/db_creation. In addition, you must manually modify the table space names in the following SQL files. This modification must happen before you start the migration to InfoSphere MDM Collaboration Server V11.4.

Table 1. SQL files to modify when you use custom table space names
SQL files to modify when DB2® is the back-end database	SQL files to modify when Oracle is the back-end database
Modify the table space names from USERS, INDX, and BLOB_TBL_DATA to appropriate custom table space names in the following SQL files in the $TOP/src/db/schema/dbscripts/db2 directory: modifySstShared.sql addCehEntryId.sql addCehEntryId.sql	Modify the table space names from USERS, INDX, and BLOB_TBL_DATA to appropriate custom table space names in the following SQL files in the $TOP/src/db/schema/dbscripts/oracle directory: add_sca_index.sql add_sit_index1.sql

About this task

The following steps are the only way to migrate from InfoSphere MDM Server for PIM V9.1.0 to InfoSphere MDM Collaboration Server V11.4, and no other means. You cannot use the environment export and import tool.

Procedure

Back up the existing database schema.
Install InfoSphere MDM Collaboration Server V11.4 in a different directory.
Set up your database.
1. For DB2 databases, create new buffer pools and table spaces as mentioned in Setting up your DB2 database in the installation guide.
  Note: The size of the XML_DATA table space must be equal to the space occupied by the TCTG_ITD_ITEM_DETAIL table space. You can find the approximate size of the table by using the following query:
```
select (fpages * 16) / 1024 megabytes from syscat.tables 
where tabschema = current schema 
and tabname like 'TCTG_ITD_ITEM_DETAIL';
```
2. For Oracle databases, create new table spaces and then install Oracle XML DB component as mentioned in Setting up your Oracle database in the installation guide.
Point the InfoSphere MDM Collaboration Server V11.4 instance to the V9.1.0, Fix Pack 2 or later database schema. To point the instance to the database, add the database parameters in the env_settings.ini file. For more information, see Setting the common database parameters.
Run the migrateFrom910FP.sh migration script. This script is available in the $TOP/bin/migration directory. See the Results section for the migration summary. If the migration was not successful, you can run the migration script again.
Migrate your data as mentioned in Migrating master data from internal format to XML format.
Run the test_db.sh script to verify the database schema, the connectivity between InfoSphere MDM Collaboration Server and databases, and to check for JDBC and native client connections. For more information, see test_db.sh script.
Start the InfoSphere MDM Collaboration Server V11.4 instance.

Results

All messages, such as the status of individual migration components and the overall migration summary, are displayed in the console.

After you run the migration script, messages are displayed in the console that indicates whether the migration succeeded or failed.

This message is displayed if the migration succeeded:

-----------------------------------------------------------
Summary of the migration
-----------------------------------------------------------
Migration to IBM InfoSphere Master Data Management 
Collaboration Server Version 11.4.0 is complete. Check the
messages for any errors.

Generating database verification report...

___________________________________________________________

Changed tables

===========================================================
There are no changed tables 
___________________________________________________________


___________________________________________________________

Missing Tables

===========================================================
There are no missing tables
___________________________________________________________


___________________________________________________________

Changed Indexes

===========================================================
There are no changed indexes
___________________________________________________________


___________________________________________________________

Missing Indexes

===========================================================
There are no missing indexes
___________________________________________________________

LOG FILE: $TOP/logs/default/default.log

This message is displayed if the migration failed:

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 Migration Failed :  xxxx
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 Please see the file for further details :  /home/pimuser/mdmcs11/logs/errfile.log

This message is displayed if the migration of specific modules failed:

-----------------------------------------------------------
Summary of the migration
-----------------------------------------------------------
Migration of the following modules failed :
<module names>

This message is displayed if there is a discrepancy in database tables or indexes.

Generating database verification report...

___________________________________________________________

Changed tables

===========================================================
<table names>
___________________________________________________________


___________________________________________________________

Missing Tables

===========================================================
<table names>
___________________________________________________________


___________________________________________________________

Changed Indexes

===========================================================
<index names>
___________________________________________________________


___________________________________________________________

Missing Indexes

===========================================================
<index names>
___________________________________________________________

LOG FILE: $TOP/logs/default/default.log

Review the errfile.log file for more messages. For SQL errors, find the detailed error message from the SQL error code, correct the error, and run the migration script again. For recommended action on migration failures, refer to Troubleshooting migration issues. Contact IBM Software Support if the problem persists after you rectify the errors.

Last updated: 22 Jul 2017