Updating the database to the latest database schema

As part of applying an update package, you need to update your database to ensure that your environment database supports any changes to the database schema.

To update your database, you need to use the updatedb utility. This utility updates the HCL Commerce database to the latest release level that is installed on your system.

Running the utility can affect database performance. Before running the updatedb utility, ensure that the database is tuned. If the database is not tuned, the utility can take longer to complete.

Procedure

  1. Back up the database.
    You must back up due to the fact that you must restore the database to the earlier version if you ever chose to uninstall (or revert) the update. For more information about how to back up your IBM Db2 database, see BACKUP DATABASE COMMAND.
  2. HCL Commerce Version 9.0.0.2Update the wcs.9.0.0.2.bootstrap.xml file.
    HCL is aware of an issue with an XML file in the Version 9.0.0.2 Update Package that causes the updatedb utility to fail. The fix will be resolved in the next update. Complete the following steps to immediately fix the issue and finish the update to Version 9.0.0.2.
    1. Enter the Utility server Docker container and open the /opt/WebSphereCommerceServer90/schema/data/xml/9.0.0/wcs.9.0.0.2.bootstrap.xml file for editing.
    2. Wrap the contents of the file with <import> </import>.
    3. Save the file.
  3. Run the updatedb utility to update your database.

Results

Your HCL Commerce database is updated to the version of the schema that is required for the version of HCL Commerce that you are installing.