Completing the IBM Websphere Commerce Version 7 Feature Pack 6 live database migration
After you successfully migrate your live IBM Websphere Commerce Version 7 database to HCL Commerce Version 9, there are final database tasks to complete before you can switch your traffic over to the HCL Commerce Version 9 environment.
Procedure
-
Update your SITE table by running the following two commands.
-
delete from site where COMPNAME not IN ('BASE');
-
update SITE set VERSION = 9, MOD=0, FIXPACK=0 where COMPNAME IN ('BASE');
-
- Update your SRCHCONF to contain the new HCL Commerce Version 9 preprocess directory by
running the following command:
Where:update SRCHCONF set CONFIG = replace(CONFIG, 'old_PreProcessdir', 'new_PreProcessdir');
- old_PreProcessdir
- The preprocess directory of the IBM Websphere Commerce Version 7 search server.
- new_PreProcessdir
- The preprocess directory of the HCL Commerce Version 9 search server.
For example,update SRCHCONF set CONFIG = replace(CONFIG,'WC_eardir/instances/demo/search/pre-processConfig/MC_10001/DB2','/v3/db2/CatalogEntry') WHERE indextype='CatalogEntry'; update SRCHCONF set CONFIG = replace(CONFIG,'WC_eardir/instances/demo/search/pre-processConfig/MC_10001/DB2/CatalogGroup','/v3/db2/CatalogGroup') WHERE indextype='CatalogGroup';
-
Update your SRCHCONF tables to contain the new search web server host name by running the
following command:
Where:update SRCHCONF set CONFIG = replace(CONFIG, 'old_hostname', 'new_hostname');
- old_hostname
- The fully qualified host name of the IBM Websphere Commerce Version 7 search web server.
- new_hostname
- The fully qualified host name of the HCL Commerce Version 9 search web server.
-
If you customized any searchable attributes in IBM Websphere Commerce Version 7 and plan to use them
in HCL Commerce Version 9, you must update KEYS table for the SRCHATTR table.
- Update to NIST SP 800-131A security standards.
-
When you set up your HCL Commerce Version 9 environment, you specified an
spiuser user password. Now that your database is migrated from a previous version, your
spiuser user password might be inconsistent.
- Run the updatedb command from your utility docker.
What to do next
- Validate your migration by completing a browse and checkout flow on your HCL Commerce Version 9 storefront.
- You can now switch traffic from your IBM Websphere Commerce Version 7 environment to your HCL Commerce Version 9 environment.