Migrating to IBM Product Master Version 12.0

Edit online

To migrate to IBM® Product Master Version 12.0, you must run the appropriate migration script.

Procedure

  1. Stop the running Product Master instance.
  2. Back up the existing database schema.
  3. Install Product Master Version 12.0 into a different folder.
  4. Point the Product Master Version 12.0 instance to the database schema of existing instance, by adding the database parameters in the env_settings.ini file. For more information, see Setting the common database parameters.
  5. Run the appropriate migration script at $TOP/bin/migration folder. If the migration was not successful, you can run the migration script again.
    Product Master instance Migration script
    Version 11.4 migrateFrom1140FP
    Version 11.5 migrateFrom1150FP
    Version 11.6 migrateFrom1160FP
    See Results for the migration summary.
  6. Run the test_db.sh script to verify the database schema, connectivity between Product Master and databases, and to check for JDBC and native client connections. For more information, see test_db.sh script.
  7. Start the IBM Product Master 12.0 version 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, message that is displayed in the console indicates whether the migration was successful.
Successful migration message
-----------------------------------------------------------
Summary of the migration
-----------------------------------------------------------
Migration to IBM Product Master 12.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/ipm.log
Migration failed message
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 Migration Failed :  xxxx
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 Please see the file for further details :  /home/pimuser/mdmcs11/logs/errfile.log
Migration of specific modules failed message
-----------------------------------------------------------
Summary of the migration
-----------------------------------------------------------
Migration of the following modules failed :
<module names>
Discrepancy in the database tables or indexes message
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/ipm.log

What to do next

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. Contact IBM Software Support if the problem persists after you rectify the errors.

For recommended action on migration failures, see Troubleshooting migration issues.

For more information about the Persona-based UI issues, Troubleshooting the issues.