updatedb utility

You can use the updatedb utility to update the WebSphere Commerce database to the latest fix pack level that is installed for your system.
Before you run the updatedb utility, ensure that you back up your WebSphere Commerce database.

Running the utility can affect database performance. Consider having your database administrator tune the database before you run the utility. If the database is not tuned, the utility can take longer to complete. Refer to your database manual for specifics of tuning the database.

Note: If the utility fails during invocation, you can rerun the updatedb utility without having to restore the database. This capability can reduce potential database downtime. When you rerun the utility, the utility resumes from the point of failure.

Staging or production environment

To use the utility within a staging or production runtime environment, run one of the following commands:
  • AIXLinuxWC_installdir/bin/updatedb.sh -instanceName instance_name [currentPropFile -DdbUserPassword dbUserPassword -DdbaPassword dbaPassword]
  • WindowsWC_installdir\bin\updatedb.bat -instanceName instance_name [currentPropFile -DdbUserPassword dbUserPassword -DdbaPassword dbaPassword]
Where
DB2currentPropFile
The full path and name of the database properties file. The currentPropFile is used when a database, other than the one specified in the instance.xml file, is to be updated. For example, two databases might be configured; one for operational purposes and the other for content purposes. The currentPropFile takes the same format as the createInstance.properties file that is found in the WC_installdir/instances/instance_name/properties directory. The database section in the currentPropFile is used to acquire the parameters that are required for the updatedb command.
dbUserPassword
The WebSphere Commerce database user password.
DdbaPassword
The WebSphere Commerce database administrator user password.
WebSphere Commerce Developer

Development environment

To use the utility in a WebSphere Commerce Developer environment, run one of the following commands:
  • Apache DerbyWCDE_installdir\bin\updatedb.bat
  • DB2WCDE_installdir/bin/updatedb.bat db2 db_name db_user_name dbUserPassword
  • OracleWCDE_installdir/bin/updatedb.bat oracle db_name db_user_name dbUserPassword db_host server_port
  • For IBM i OS operating systemWCDE_installdir/bin/updatedb.bat iseries db_name db_user_name dbUserPassword db_host
Where
db_name
The name of your WebSphere Commerce Developer database. For example, WCDE_installdir/db/mall
db_user_name
The name of your WebSphere Commerce Developer database user.
dbUserPassword
The WebSphere Commerce Developer database user password.
db_host
The database server host name.
server_port
The database server host port number.

updatedb utility log file

After you run the updatedb utility, you can view the updatedb-instance_name.log log file for information about the update process. The log level is set to info. The log file generates in the following directory:
  • AIXLinuxWC_installdir/logs/update/updatedb
  • WindowsWC_installdir\logs\update\updatedb
  • WebSphere Commerce DeveloperWCDE_installdir\logs\update\updatedb