Updating encrypted data in the database using Configuration Manager

Use the Database Update Tool to change the merchant key and update all encrypted data (for example, passwords or credit card numbers) in one or more WebSphere Commerce databases for a given instance.

Note: This tool is only available if the merchant key is stored in the instance.xml file. If the merchant key is stored in another medium, see Updating encrypted data using MigrateEncryptedInfo.

Procedure

  1. Open the Configuration Manager.
  2. Traverse to your specific database entry as follows: WebSphere Commerce > node_name > Commerce > Instance List > instance_name > Instance Properties > Database > database_name .
  3. Right-click database_name and select Run Database Update Tool.
    • Select Update all databases for this instance to migrate encrypted data for all databases for the selected instance.

      For IBM i OS operating system This option does not apply.

    • Select Update selected database to migrate encrypted data for a specific database by selecting the database from the list (default).
  4. Select an action you want to run from the Action Item box, and fill in the required information in the Parameter field:

    The following table shows the parameters and actions required when you change the merchant key.

    Actions Parameters Action Required
    Change Merchant Key Old Merchant Key Enter your existing merchant key that you used when you created your current WebSphere Commerce instance.
    New Merchant Key Enter your new merchant key. This is a 16-digit hexadecimal number for the Configuration Manager to re-encrypt the currently encrypted data. The Merchant Key must have at least one alphanumeric character (a to f) and at least one numeric character (0 to 9). Any alphanumeric character must be entered in lower case letters, and you cannot have the same character entered more than four times in a row.
  5. Click OK to run the database update tool for your selected WebSphere Commerce database or for all your WebSphere Commerce databases.
  6. Upon successfully updating the configuration for your instance, you will receive a message indicating a successful update.
  7. Restart your WebSphere Commerce instance.