Preparing to migrate the WebSphere Commerce Version 7 Feature Pack 6 production database

Now that you have migrated your development environment and deployed the containers in WebSphere Commerce Version 9.0.0.1+, we can now build and deploy our customizations, and migrate the WebSphere Commerce Version 7 database to WebSphere Commerce Version 9.0.0.1+.

Migrating the production database is broken up into two parts. First, you back up and restore the WebSphere Commerce Version 7 production database to the WebSphere Commerce Version 9.0.0.1+ environment, where we can test the container technology with an offline version of the WebSphere Commerce Version 7 production database. After your testing is complete, we can execute the second part of the migration, which is where you point the WebSphere Commerce Version 9.0.0.1+ environment to your live WebSphere Commerce Version 7 database, then migrate that database while still serving traffic from your online storefront.


Before beginning

  1. By using the WCB tool, build your migrated custom assets into input packages

  2. Deploy our customizations to the WebSphere Commerce application.


Procedure

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

  2. Back up the WebSphere Commerce Version 7 production database:

  3. Restore the backup of the WebSphere Commerce Version 7 production database to the WebSphere Commerce Version 9 production database server.

  4. (DB2) Ensure that your SYSADMIN user has DBADM authority. For more information about granting this user authority, see step 2.

  5. (DB2) Update the restored 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 an offline version of our production database.