Migrate > Migrating WebSphere Commerce Developer > Migrating the database > Use the Migration wizard



Back up and restoring System i database

The Migration wizard prompts if a database backup and restore is completed. Restore the System i database backup image to your database server for WebSphere Commerce Developer v7.0. The restored database backup is what is migrated in order to keep the current environment functioning. The Migration wizard will not allow you to continue until database backup, restore, or both have been completed


Procedure

  1. Sign on to the system, with a *SECOR profile, where the WebSphere Commerce, version 6.0 instance schema exists.

  2. Save the WebSphere Commerce, version 6.0 schema with the SAVLIB command: SAVLIB LIB(instance) DEV(*SAVF) SAVF(templib/instance) ACCPTH(*YES) To perform backup and restore on a single system, go to step 3.

    To perform backup and restore over two systems, go to step 4.

  3. To perform backup and restore on a single system:

    1. On the WebSphere Commerce, version 6.0 machine, create a new user profile with the name that the new migrated WebSphere Commerce 7.0 instance will use. Ensure the profile has the appropriate localized settings, shown in the following table:

      Localized settings
      Language System i5 value

      - QCCSID

      		System i5 value

      -QLANGID

      		System i5 value

      -QCNTRYID

      English 37 ENU US
      French 297 FRA FR
      German 273 DEU DE
      Italian 280 ITA IT
      Spanish 284 ESP ES
      Brazilian Portuguese 37 PUB BAR
      Japanese 5035 DPN JP
      Korean 933 OR OR
      Traditional Chinese 937 CHT TWO
      Simplified Chinese 935 CHS CAN

      The new user profile will be new_instance_profile.

    2. Ensure new_instance_profile has *SECOFR authority.

      If the database is remote from the WebSphere Commerce system, repeat step 3. The profile must be created on both the remote database machine and the local WebSphere Commerce machine.

    3. Sign off from the system and sign on to the WebSphere Commerce, version 7.0 system using the new_instance_profile user profile.

    4. Do the following steps:

      1. Start a QSH session (STRQSH command)

      2. Navigate to directory WC_INSTALL/bin

      3. Run the copyDB command as shown: 

        copyDB.sh HOSTNAME DATABASE_NAME NEW_INSTANCE_NAME 
NEW_INSTANCE_PWD OLD_INSTANCE_NAME EMPTYLIB

        Where:

        • HOSTNAME is the host name of the machine where the database resides.

        • DATABASE_NAME is the relational database name of the machine where the database resides. You can display this using the WRKRDBDIRE command.

        • NEW_INSTANCE_NAME is the name of the new instance (new_instance_profile).

        • NEW_INSTANCE_PWD is the password of the new instance.

        • OLD_INSTANCE_NAME is the name of the old instance.

        • EMPTYLIB is a native library used by migration for temporary storage (this library is created or cleared as required).

        If the database is remote, the DSPSAVF command is run on the remote database machine. The newly created database schema NEW_INSTANCE_NAME is the database that will be migrated to the WebSphere Commerce, version 7.0 level.

  4. To perform backup and restore over two different systems:

    1. Transfer the SAVF to the target machine using File Transfer Protocol (FTP) in binary (BIN) mode.

    2. Sign on to the target machine with a *SECOFR profile.

    3. Restore to the same library name:

      1. Create a new user profile with the name of the WebSphere Commerce, version 6.0 instance. The new user profile is instance.

      2. Ensure the profile has the appropriate localized settings as shown in Table 1.

      3. Ensure instance has *SECOFR authority.

      4. Sign off from the target system and sign back on to the target system with the instance user profile.

      5. Use the RSTLIB command to restore the WebSphere Commerce, version 6.0 schema to the same library name. For example: 

        RSTLIB SAVLIB(instance)
DEV(*SAVF) SAVF(templib/instance)

  5. Sign off from the system.


+

Search Tips   |   Advanced Search