Migrating the WebSphere Commerce database by using the Migration wizard

The Migration wizard provides a graphical interface to help you perform both the premigration check and the migration on your WebSphere Commerce database.

The Migration wizard server runs on the system where WebSphere Commerce Version 8.0 is installed. For systems without graphic support, launch the Migration wizard client from another system that does have graphic support.

Before you begin

Review the following information before you start the database migration:

If you are migrating the WebSphere Commerce database from one system (source) to another system (target), use the same database user on the target system as the source system.
The schema name that you specify when you migrate the database must be same as the user name. If the user name is different than the schema name, you must transfer the schema to a schema that has same name as user. For information on how to transfer the schema name to another name, refer to one of the following:
- DB2 10.5: ADMIN_COPY_SCHEMA procedure
- For instructions on how to change the schema name, see the database vendor documentation.
Alternately, you can create a new database user that has the same name as the current schema, then use this user to migrate the database.
Ensure that the X11 graphic library is installed.
Ensure that the following directory is executable by the non-root user. Only the top-level directory must be executable, not any subdirectories.
- /root
Note: Any permissions modification can be reversed following the upgrade.
Ensure that the following files are readable by the non-root user:
- /root/vpd.properties
- WC_installdir/instances/instance_name/xml/instance_name.xml
If you are running the Migration wizard on a system that is different from your WebSphere Commerce Version 7.0, copy the following file from your version 7.0 environment to your version 8.0 environment:WC_installdir/instances/instance_name/xml/instance_name.xml
Note: During the migration, you are prompted for the location of this XML file.
Ensure that you increase the file handle limit. As the WebSphere Commerce root user, issue the following command:
```
ulimit -n 8192
```

Procedure

The Migration wizard server must be launched from the WebSphere Commerce Version 8.0 system. The Migration wizard client can be run on any system with graphic support.

To start the Migration wizard server:
1. Complete one of the following steps:
  - Sign on with the non-root user and start a command line console.
  - Open a DOS command window.
  - Start a Qshell session.
2. Go to directory: WC_installdir/bin.
3. Complete one of the following tasks:
  - wcimServer.sh [-port port_number -loglevel log_level]
  - wcimServer.bat [-port port_number -loglevel log_level]
  Where:
  
  port_number
  
  The number of the endpoint port. If a number is specified, the value must be 1024 - 65535. If a number is not specified, the default number is 10,999.
  
  log_level
  
  The level of logging can be set to ERROR, WARNING, INFO, DEBUG, or VERBOSE. The default value is VERBOSE.
4. Wait for the following message to be displayed:
```
Event: WCIM server started with protocol rmi at port 10,999.
```
  This message indicates that the server started successfully.
To start the Migration wizard client:
1. Complete one of the following steps:
  - Sign on with the non-root user and start a command line console.
  - Open a DOS command window.
2. Complete one of the following tasks, depending on the location of the Migration wizard server:
  - Local server: The Migration wizard server and client are running on the same system. Enter one of the following commands:
    - wcimClient.sh
    - wcimclient.bat
  - Remote server: The Migration wizard server and client are running on different systems. Enter one of the following commands:
    - wcimRemoteClient.sh -hostname hostname [-portport_number -loglevel log_level]
    - wcimRemoteClient.bat -hostname hostname [-port port_number -loglevel log_level]
    Where:
    
    hostname
    
    The host name of the system where the Migration wizard server is running.
    This is the fully qualified host name of the System i.
    
    port_number
    
    The number of the endpoint port. If a number was specified to start the Migration wizard server, the same port number value must be specified for the client.
    
    log_level
    
    The level of logging can be set to ERROR, WARNING, INFO, DEBUG, or VERBOSE. The default value is VERBOSE.
The Migration wizard's default user is wcsadmin and the default password is wcimibm. Use these values to sign in.
Select a product to be migrated, then click Launch.
Interact with the Migration wizard to complete a database check and database migration.

To access the online help, click Help > Online Help.

Refer to the following Migration wizard log file to address any warnings or errors during the database check and migration: WC_installdir/logs/WCIM/wcim.server.yyyy.mm.dd_hh.mm.ss.log.

What to do next

Complete the database migration.