WebSphere Commerce EnterpriseWebSphere Commerce Professional

Migrating your LikeMinds DB2 database

If you are using DB2, migrate your database using the following scripts. Run these scripts in order and check their output to make sure no problems have occurred before you proceed to run the next script.

Important: This procedure is not required when migrating LikeMinds from WebSphere Commerce 5.6.1 or 6.0 to WebSphere Commerce 7 and will corrupt your data.

Procedure

  1. Back up your current LikeMinds database. Refer to the DB2 product documentation for backup instructions.
  2. From a command line window, scroll to the following directory:
    • For IBM i OS operating systemWC70_userdir/likeminds/migration/db2
    • LinuxWC70_installdir/likeminds/migration/db2
    • WindowsWC70_installdir\likeminds\migration\db2
  3. Connect to the database using the following SQL statement: 
    db2 connect to LikeMinds_database_name user user_id using user_password
  4. Clean up all user and item data that is not used by the WebSphere Commerce integration by running the lm_dataClean.sql script: 
    db2 -tvf lm_dataClean.sql
  5. Migrate the database schema by running the lm_migration.sql script: 
    
db2 -tvf lm_migration.sql
  6. Switch to the following directory:
    • For IBM i OS operating systemWC70_userdir/likeminds/config
    • LinuxWC70_installdir/likeminds/config
    • WindowsWC70_installdir\likeminds\config

      Populate the database with the LikeMinds configuration data by running the lm_Props.sql script:

      
db2 -tvf lm_Props.sql
  7. Switch back to the following directory:
    • For IBM i OS operating systemWC70_userdir/likeminds/migration/db2
    • Linux WC70_installdir/likeminds/migration/db2
    • Windows WC70_installdir\likeminds\migration\db2

      Rebuild the LikeMinds database mentor table by running the lm_rebuild_mentor.sql script:

      
db2 -tvf lm_rebuild_mentor.sql
  8. Exit the database connection by running: 
    db2 TERMINATE