Draft Document for Review July 28, 2004 7:33 pm

6320ch_migrating.fm

db2 create index <index name> on <table name> ( <column names> <order>)

The index exists but on the wrong table. Typically it would exist on the same tablename with an ‘_OLD appended to it (e.g for above mentioned table the index would exist on ‘CONTRACT_OLD’ instead of on ‘CONTRACT’). To correct this error the index must be dropped and recreated on the right table:

db2 drop index <index name>

db2 create index <index name> on <table name> ( <column names> <order>)

These are the SQL commands we used in our example to correct the errors after running the migration script:

db2 create index I0000511 on campaign ( storeent_id asc)

db2 drop index I0000539

db2 create index I0000539 on contract ( member_id asc)

db2 create index I0000588 on initiative ( storeent_id asc)

db2 drop index I0000824

db2 create index I0000824 on userpvcdev ( users_id asc)

Note: review the log file for the values for the following parameters <index

name>, <table name>, <column names> and <order>.

11.3.2 Choosing the master catalog

When the migrate database script is running it will generate some SQL scripts which can be used after migration. These scripts are located in the following directory:

<wc56_home>\instances\demo\migration

One of the SQL scripts generated, is the choosemc.sql. This SQL is used for selecting one of the catalogs as the master catalog. This script is only generated if the migrate database scripts detects more than one catalog in the WebSphere Commerce system. If only one catalog is found, it is set as the master catalog. Prior to running the script it must be modified to the correct catalog IDs. This is done by replacing every instance of MASTERCATALOG_ID with the catalog ID which is the master catalog. In our example the content of the file was updated as described in the following example.

Example 11-3 The content of the modified choosemc.sql file

--store :10001 has 2 catalogs. --catalog:10001 --catalog:10002

Chapter 11. Migrating WebSphere Commerce components 213

Page 231
Image 231
IBM SG24-6320-00 manual Choosing the master catalog, Example 11-3 The content of the modified choosemc.sql file