updatedb utility

The updatedb utility updates the Commerce+ Transaction Server database to the latest release level that is installed on your system.
Ensure that you have backed up your Commerce+ Transaction Server 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+ Transaction Server database type. Accepted values are db2, oracle, or postgres.
dbName
The Commerce+ Transaction Server database name. For example, mall.
dbUserName
The Commerce+ Transaction Server database application user name.
dbUserPassword
The Commerce+ Transaction Server database application user password.
dbHostname
The Commerce+ Transaction Server database hostname or IP address.
dbServerPort
The Commerce+ Transaction Server database port number.
dbaName
The Commerce+ Transaction Server database administrator user name.
dbaPassword
Optional: The Commerce+ Transaction Server database administrator user password.
schemaName
Optional: The Commerce+ Transaction Server database application schema name.
jdbcURL
The Commerce+ Transaction Server 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+ Transaction Server 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