Preparing to migrate your IBM Websphere Commerce Version 7 Feature Pack 8 development database

Prepare to migrate your development database by backing up your IBM Websphere Commerce Version 7 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 7 development database. In particular, ensure that any rows you added for custom tables have valid data.

About this task

The following steps are to be completed on your HCL Commerce Version 9 development environment.

Procedure

1. Back up your IBM Websphere Commerce Version 7 development database:
   • Db2 backup overview
   • Oracle Database Backup and Recovery Reference
2. Restore the backup of your IBM Websphere Commerce Version 7 development database to your HCL Commerce Version 9 development environment.
   • Db2 restore overview
   • Oracle Database Backup and Recovery Reference
3. Point your HCL Commerce Version 9 development environment to the restored IBM Websphere Commerce Version 7 development database.
4. Update 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