Preparing to migrate your IBM Websphere Commerce Version 8 development database

Prepare to migrate your development database by backing up your IBM Websphere Commerce Version 8 development database, then restore the database backup to your HCL Commerce Version 9 development environment. Next, point the HCL Commerce Version 9 development environment to the restored database backup.

Before you begin

  1. Ensure that the data in your KEYS table is valid in your IBM Websphere Commerce Version 8 development database. In particular, ensure that any rows you added for custom tables have valid data.
  2. Db2 restore overview

About this task

Note: If you are upgrading from HCL Commerce V8 to V9.1, the minimum supported DB2 version is v11.5, while the latest supported version is v12.1.4. This simplifies the transition to newer DB2 database versions.
The following steps are to be completed on your HCL Commerce Version 9 development environment.

Procedure

  1. Back up your WebSphere Commerce development database:
  2. Restore the backup of your IBM Websphere Commerce Version 8 development database to your HCL Commerce Version 9 development environment.
  3. Point your HCL Commerce Version 9 development environment to the restored IBM Websphere Commerce Version 8 development database.
  4. DB2Update the restored Db2 database configure with the following configuration.
    DB2 parameter Value
    locklist 2400
    indexrec RESTART
    logfilsiz 1000
    logprimary 12
    logsecond 10
    pckcachesz 4096
    catalogcache_sz 4096
    locktimeout 45
    • To see database configurations:
      db2 get db cfg for database_name
      For example:
      db2 get db cfg for mall
    • To update database configurations:
      db2 update db cfg for database_name using parameter_name parameter_value
      For example:
      db2 update db cfg for mall using locklist automatic logprimary 150 logsecond 100 pckcachesz automatic