For IBM i OS operating system

Backing up and restoring IBM i database

The Migration wizard prompts if a database backup and restore is completed. Restore your IBM i database backup image to your database server for WebSphere Commerce Developer Version 7.0. It is the restored database backup that 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_name) DEV(*SAVF) SAVF(templib/instance_name) ACCPTH(*YES)
  3. Back up and restore the database.
    The steps differ according to whether you are performing the backup and restore on a single system or over two different systems.
    • To perform backup and restore on a single system:
      • Use the RSTLIB command to restore the WebSphere Commerce, version 6.0 schema to the same library name. For example:
        RSTLIB SAVLIB(instance_name)
        DEV(*SAVF) SAVF(templib/instance_name)
        where instance_name is the same name as WebSphere Commerce Version 6.0 schema.
    • 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_name. Ensure the profile has the appropriate localized settings, as shown in the following table.
          Localized settings
          Language System value

          - QCCSID

          System value

          -QLANGID

          System 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
        2. Ensure instance_name has *SECOFR authority.
        3. Sign off from the target system and sign back on to the target system with the instance_name user profile.
        4. Use the RSTLIB command to restore the WebSphere Commerce Version 6.0 schema to the same library name. For example:
          RSTLIB SAVLIB(instance_name)
          DEV(*SAVF) SAVF(templib/instance_name)
          where instance_name is the same name as WebSphere Commerce Version 6.0 schema.
      4. Sign off from the system.