Completing the database migration

After you successfully migrate your staging database, complete the final database migration tasks.

Procedure

  1. Update your SRCHCONF to contain the new version 8.0 preprocess directory by running the following command:
    update SRCHCONF set CONFIG = replace(CONFIG, 'old_PreProcessdir', 'new_PreProcessdir');
    Where:
    old_PreProcessdir
    The preprocess directory of the version 7.0 search server.
    new_PreProcessdir
    The preprocess directory of the version 8.0 search server.
  2. Update your SRCHCONFEXT tables to contain the new search web server host name by running the following command:
    update SRCHCONFEXT set CONFIG = replace(CONFIG, 'old_hostname', 'new_hostname');
    Where:
    old_hostname
    The fully qualified host name of the version 7.0 search web server.
    new_hostname
    The fully qualified host name of the version 8.0 search web server.
  3. If you used catalog filters and pricing rules in version 7.0 and plan on using those functions in version 8.0, you need to enable them manually.
    1. Connect to your database.
    2. Set the VALUE for the wc.search.entitlement property to 1 by using the following SQL command:
      UPDATE STORECONF SET VALUE='1' WHERE STOREENT_ID=STOREENT_ID AND NAME='wc.search.entitlement';
      Where:
      STOREENT_ID
      The STOREENT_ID for your store.
    3. Repeat for all applicable STOREENT_ID entries.
  4. If you customized any searchable attributes in version 7.0 and plan to use them in version 8.0, you must update KEYS table for the SRCHATTR table.
    1. Connect to your database.
    2. Run the following SQL command:
      update keys set counter = case when (select max(srchattr_id) from srchattr) > 
      counter then (select max(srchattr_id) from srchattr) else counter end where tablename = 'srchattr'
    3. Restart the WebSphere Commerce Version 8.0 server.
  5. Update your database to the latest Mod Pack and Fix Pack level by running the updatedb utility.
  6. If you are migrating from WebSphere Commerce Version 7 Feature Pack 1, Feature Pack 2, Feature Pack 3, Feature Pack 4, Feature Pack 5, or Feature Pack 6, and you have configured workspaces and have already run the update workspaces schema script after migrating, run the following SQL statement in each workspace write schema:
    • Cloudscape:
      ALTER TABLE PAGELAYOUT ALTER COLUMN PAGELAYOUTTYPE_ID NULL;
    • DB2:
      ALTER TABLE PAGELAYOUT ALTER COLUMN PAGELAYOUTTYPE_ID DROP NOT NULL;
      
      CALL SYSPROC.ADMIN_CMD ('REORG TABLE PAGELAYOUT');
    • Oracle:
      ALTER TABLE PAGELAYOUT MODIFY PAGELAYOUTTYPE_ID NULL;