Prepare to migrate the WebSphere Commerce Version 8 development database

Prepare to migrate the development database by backing up the WebSphere Commerce version 8.0 development database, then restore the database backup to the WebSphere Commerce Version 9.0.0.1+ development environment. Next, point the WebSphere Commerce Version 9.0.0.1+ development environment to the restored database backup.


Before beginning

  1. Ensure that the data in your KEYS table is valid in the WebSphere Commerce Version 7 development database. In particular, ensure that any rows you added for custom tables have valid data.


Task info

The following steps are to be completed on the WebSphere Commerce Version 9.0.0.1+ development environment.


Procedure

  1. Back up your version 8.0 development database:

  2. Restore the backup of your version 8.0 development database to the WebSphere Commerce Version 9 development environment.

  3. Point the WebSphere Commerce Version 9.0.0.1+ development environment to the restored WebSphere Commerce Version 7 development database.

  4. (DB2) 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


Next topic: Migrate the development database.