To migrate to IBM® InfoSphere® Master Data Management Collaboration Server Version 11.3.0 from IBM InfoSphere Master Data Management Collaboration Server Version 11.0.0, you must run the appropriate migration script.
If you are using custom table space names instead of the default USERS or INDX, you must manually modify the table space names in the following SQL files. You must modify the names before you start the migration to InfoSphere MDM Collaboration Server Version 11.3.0.
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:
addSstShared.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: addSstShared.sql |
You can migrate to InfoSphere MDM Collaboration Server Version 11.3.0 from InfoSphere MDM Collaboration Server Version 11.0.0 GA, Fix Pack 1, Fix Pack 2, or Fix Pack 3.
The following steps are the only way to migrate from InfoSphere MDM Collaboration Server V11.0.0 to V11.3.0, and no other means. You cannot use the environment export and import tool.You can configure the error log file location by modifying the _ERROR_LOGS variable in the migrateFrom1100.sh migration script. This variable is set to $TOP/logs/errfile.log by default.
After you run the migration script, messages are displayed in the console that indicates whether the migration succeeded or failed.
-----------------------------------------------------------
Summary of the migration
-----------------------------------------------------------
Migration to IBM InfoSphere Master Data Management
Collaboration Server Version 11.3.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
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Migration Failed : xxxx
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Please see the file for further details : /home/pimuser/mdmcs11/logs/errfile.log
-----------------------------------------------------------
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.