Prepare to migrate the WebSphere Commerce Version 8 staging database

Prepare the WebSphere Commerce Version 8 staging database for migration by taking a backup of the database, then restoring the database to the WebSphere Commerce Version 9 staging server.

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 8 database. In particular, ensure that any rows you added for custom tables have valid data.

2. Back up the WebSphere Commerce Version 8 staging database:

   • (DB2) Db2 backup overview

   • (Oracle) Oracle Database Backup and Recovery Reference

3. Restore the backup of the WebSphere Commerce Version 8 staging database to the WebSphere Commerce Version 9 staging database server.

   • (DB2) Db2 restore overview

   • (Oracle) Oracle Database Backup and Recovery Reference

4. (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 the staging database.