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.
WebSphere Commerce Version 7.0.0.7 or laterNote: Interim fix JR52690 introduces a new capability to reduce potential database downtime if the updatedb utility fails during invocation. You can rerun the updatedb utility without having to restore the database, and the utility resumes from the point of failure.

Staging or production environment

To use the utility within a staging or production run time environment, run one of the following commands:
WebSphere Commerce Version 7.0.0.3WebSphere Commerce Version 7.0.0.6WebSphere Commerce Version 7.0.0.5WebSphere Commerce Version 7.0.0.7WebSphere Commerce Version 7.0.0.2WebSphere Commerce Version 7.0.0.1WebSphere Commerce Version 7.0.0.4
  • SolarisLinuxAIXWC_installdir/bin/updatedb.sh instance_name [currentPropFile]
  • WindowsWC_installdir\bin\updatedb.bat instance_name [currentPropFile]
WebSphere Commerce Version 7.0.0.8
  • SolarisLinuxAIXWC_installdir/bin/updatedb.sh instance_name [currentPropFile -DdbUserPassword dbUserPassword -DdbaPassword dbaPassword]
  • WindowsWC_installdir\bin\updatedb.bat instance_name [currentPropFile -DdbUserPassword dbUserPassword -DdbaPassword dbaPassword]
WebSphere Commerce Version 7.0.0.9
  • SolarisLinuxAIXWC_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 cloudscape
  • 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:
  • SolarisLinuxAIXWC_installdir/logs/updatedb
  • WindowsWC_installdir\logs\updatedb
  • WebSphere Commerce DeveloperWCDE_installdir\logs