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.
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:- WC_installdir/bin/updatedb.sh -instanceName instance_name [currentPropFile -DdbUserPassword dbUserPassword -DdbaPassword dbaPassword]
- WC_installdir\bin\updatedb.bat -instanceName instance_name [currentPropFile -DdbUserPassword dbUserPassword -DdbaPassword dbaPassword]
- currentPropFile
- 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 thecreateInstance.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.
Development environment
To use the utility in a WebSphere Commerce Developer environment, run one of the following commands:- WCDE_installdir\bin\updatedb.bat
- WCDE_installdir/bin/updatedb.bat db2 db_name db_user_name dbUserPassword
- WCDE_installdir/bin/updatedb.bat oracle db_name db_user_name dbUserPassword db_host server_port
- WCDE_installdir/bin/updatedb.bat iseries db_name db_user_name dbUserPassword db_host
- 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:- WC_installdir/logs/update/updatedb
- WC_installdir\logs\update\updatedb
- WCDE_installdir\logs\update\updatedb