DB2

Preparing custom tables for migration

If you have any custom tables with a foreign key reference to certain WebSphere Commerce tables, you will need to perform this task to prepare for migration.

About this task

Perform the premigration steps if a custom table has a foreign key reference to any of the following WebSphere Commerce tables:
  • ACCOUNT
  • ATCHAST
  • ATCHTGT
  • ATCHTGTDSC
  • CATENTDESC
  • CATENTRY
  • CATGROUP
  • CATGRPDESC
  • COLLATERAL
  • CMFILE
  • DMACTIVITY
  • DMCAMPAIGN
  • EMLMSG
  • EMSPOT
  • GRADDR
  • MBRGRP
  • PX_PROMOAUTH
  • PX_PROMOCD
  • STORE

Procedure

  1. Before you migrate the database, open the file wc_installdir/schema/migration/60/db2/wcs.restore.bootstrap.sql and append the following SQL statement: 
    set integrity for table_name immediate checked;
    where table_name is the name of the custom table that contains one or more of foreign key references to the tables listed.
  2. Repeat Step 1 for every table that has a foreign key reference to any of tables listed.
  3. Migrate the database.