Migrating HCL Commerce Version 9.1 databases

This document provides step-by-step instructions for migrating Commerce+ databases (DB2 or Oracle) from version 9.1.x.0 to HCL Commerce+ using the wcim_ant utility. It includes guidance for Development, Staging, and Production database environments.

Pre-requisite

Before you migrate to HCL Commerce+ from HCL Commerce Version 9.1, review this information to help plan and execute your migration.

To initiate the migration, ensure the customer environment is on Commerce+ version 9.1.20.0 or higher. The migration process supports migrating to HCL Commerce+ version 26.07.22 (July 2026) and onward.

Best practices for Database migration
Backup everything first
Always complete the backup of the source database before starting migration. Retain backups until post-migration verification is complete.
Use a Non-Production Environment First
To uncover potential issues early, perform trial migrations in a development or staging environment.
Monitor Logs Closely
Use -logLevel Verbose for all wcim_ant executions. Review the logs immediately after each migration step for errors or warnings.
Set Maintenance Windows
Schedule the migration during a designated maintenance window to avoid disruption to business operations.
Post-Migration Validation
To confirm application stability, test core functionalities like storefront access, catalog browsing, order placement, and admin tools.
Update SITE Table Correctly
Ensure the SITE table version is correctly updated and audited as part of the migration checklist.
High-Level Migration Steps
  1. Back up the 9.1.x.0 database and restore it to the HCL Commerce+ database environment.
  2. Run pre-migration checks using the wcim_ant tool.
  3. Perform the database migration using wcim_ant.
  4. Update the SITE table version.
  5. Run the updatedb utility from the HCL Commerce+ environment.