Migrating your LikeMinds DB2 database

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.

Warning: This procedure is not required when migrating LikeMinds from WebSphere Commerce 5.6.1 to WebSphere Commerce 6.0 and will corrupt your data.
Back up your current LikeMinds database. Refer to the DB2 product documentation for backup instructions.
From a command line window, scroll to the following directory:

(i5/OS)WC60_userdir/likeminds/migration/db2
(Linux)WC60_installdir/likeminds/migration/db2
(Windows)WC60_installdir\likeminds\migration\db2
Connect to the database using the following SQL statement:
db2 connect to LikeMinds_database_name user user_id using user_password
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
Migrate the database schema by running the lm_migration.sql script:
db2 -tvf lm_migration.sql
Switch to the following directory:
(i5/OS)WC60_userdir/likeminds/config
(Linux)WC60_installdir/likeminds/config
(Windows)WC60_installdir\likeminds\config
Populate the database with the LikeMinds configuration data by running the lm_Props.sql script:
db2 -tvf lm_Props.sql
Switch back to the following directory:
(i5/OS)WC60_userdir/likeminds/migration/db2
(Linux)WC60_installdir/likeminds/migration/db2
(Windows)WC60_installdir\likeminds\migration\db2
Rebuild the LikeMinds database mentor table by running the lm_rebuild_mentor.sql script:
db2 -tvf lm_rebuild_mentor.sql
Exit the database connection by running:
db2 TERMINATE
Related concepts

WebSphere Commerce Recommendation Engine powered by LikeMinds
Related tasks

Migrate LikeMinds Personalization Server

Migrate the LikeMinds database

(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.