Database schema migration

If the fix pack needs database schema migration, complete the steps that are listed here.

Before you begin

Important:

Ensure that the database user for InfoSphere® Master Data Management Collaboration Server - Collaborative Edition application has appropriate database privileges as mentioned DB2® privileges or Oracle privileges. If the database privileges are modified for any reason, the migration script fails.
Ensure that the InfoSphere Master Data Management Collaboration Server - Collaborative Edition application is stopped on the local server.
Identify the version of fix pack that you are migrating from.

Procedure

Run the migrateToInstalledFP.sh in the $TOP/bin/migration directory.
migrateToInstalledFP.sh --fromversion=BASE, FP1, FP2 [--dbpassword=<database password>]
- fromversion - Depends on the version you are migrating from.
- dbpassword (Optional) - Stores the encrypted database password in the InfoSphere Master Data Management Collaboration Server - Collaborative Edition.

Check the migration messages in the console to verify successful migration.

Types of migration messages

Message type	Message
Migration successful	-------------------------------------- Summary of the migration: -------------------------------------- Migration to InfoSphere MDM Collaboration Server 11.6.0 successful.
Migration failed	!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Migration Failed : xxxx !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Please see the file for further details : /home/pimuser/mdmcs1150/logs/errfile.log
Migration failed for specific modules	-------------------------------------- Summary of the migration: -------------------------------------- Migration of the following modules failed : <module names>

Message type

Message

Migration successful

--------------------------------------
 Summary of the migration:  
--------------------------------------
 Migration to InfoSphere MDM Collaboration Server 11.6.0 successful.

Migration failed

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

Migration failed for specific modules

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

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 more information, see Troubleshooting migration issues. Contact IBM® Software Support if the problem persists after you correct the errors.