updatedb utility

The updatedb utility updates the Commerce+ database to the latest release level that is installed on your system.
Ensure that you have backed up your Commerce+ database before running the updatedb utility.

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.

Before you begin

Before you use the updatedb utility:
  • Ensure that all default constraints and indexes are present within the database.
  • Ensure that your wc-dataload-env.xml dataload configuration file contains the following line.
    IdResolveKeyPropertyFile="${IdResolveKeyPropertyFile,}"
  • Ensure that LANGUAGE_ID in the MBRGRPDESC table has a foreign key associated with the LANGUAGE_ID in the LANGUAGE table. If this is not the case, you can encounter a Cannot resolve symbol: @en_US or related error.

Production environment

  1. Open the Utility server Docker container.
  2. Run the command: 
    ./updatedb.sh -dbType dbType -dbName dbName -dbUserName dbUserName -dbUserPassword dbUserPassword -dbHostname dbHostname -dbServerPort dbServerPort -dbaName dbaName -dbaPassword dbaPassword -jdbcURL jdbcURL -isStaging isStaging true -isSSLEnabled true
    ./updatedb.sh -dbType dbType -dbName dbName -dbUserName dbUserName -dbUserPassword dbUserPassword -dbHostname dbHostname -dbServerPort dbServerPort -dbaName dbaName -dbaPassword dbaPassword -schemaName schemaName -jdbcURL jdbcURL -isStaging isStaging true -isSSLEnabled true
Where:
dbType
The Commerce+ database type. Accepted values are db2, oracle, or postgres.
dbName
The Commerce+ database name. For example, mall.
dbUserName
The Commerce+ database application user name.
dbUserPassword
The Commerce+ database application user password.
dbHostname
The Commerce+ database hostname or IP address.
dbServerPort
The Commerce+ database port number.
dbaName
The Commerce+ database administrator user name.
dbaPassword
Optional: The Commerce+ database administrator user password.
schemaName
Optional: The Commerce+ database application schema name.
jdbcURL
The Commerce+ database JDBC URL.

For example,

postgres: jdbc:postgresql://10.0.0.1:5432/mall

DB2: jdbc:db2://10.0.0.1:50000/mall.

oracle: jdbc:oracle:thin:@//10.0.0.1:1521:orcl

isStaging
Specifies if the Commerce+ database being updated is a staging database. Set this value to true for a staging database, or false for a production database.
isSSLEnabled
This parameter adds the SSL setting to the JDBC connection string to enable or disable SSL for the database connection. Set this value to true if the database supports SSL connections, or to false if the database does not support SSL.

The updatedb utility log file

After you run the updatedb utility, you can view the utility log file for information about the update process. The log level is set to info. The log file generates in the following directories:
  • Linux/opt/CommerceUtilities/logs/updatedb/updatedb-demo.log