IBM SG24-6320-00 Marine Radio User Manual


 
6320ax02.fm Draft Document for Review July 28, 2004 7:33 pm
266 Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide
3. Apply patch for migrateencryptedinfo.bat into Utilities.jar, refer to
Chapter 11, “Migrating WebSphere Commerce components” on page 201 for
more details on why this patch is applied
4. Call WebSphere Commerce V5.6 encrypted data migration script
migrateencryptedinfo.bat to migrate the encrypted data
5. Execute choosemc.sql to assign the master catalog
Database post migration SQL script
The SQL file executes the final changes needed on the database to finish the
database migration.
The post.migration.sql file will perform the following tasks:
1. Correct the index errors introduced by migratedb.bat
2. Remove records with non-encrypted values starting with space. Refer to
Chapter 11, “Migrating WebSphere Commerce components” on page 201 for
more details on this.
The content of the post.migration.sql file:
Example: C-5 Content of post.migration.sql file
-- CORRECT INDEX ERRORS DURING DB MIGRATION
create index I0000511 on campaign ( storeent_id asc);
drop index I0000539;
create index I0000539 on contract ( member_id asc);
create index I0000588 on initiative ( storeent_id asc);
drop index I0000824;
create index I0000824 on userpvcdev ( users_id asc);
-- DELETE ORDPAYINFO VALUES THAT STARTS WITH ' ' SO IT IS NOT ASSUMED TO BE A ENCRYPTED VALUE
delete from ordpayinfo where value like ' %';