Administer > Manage WebSphere Commerce features > Enable Workspaces > Author server schema update tool > Run the authoring server update scripts on the WebSphere Commerce Server

ANT target: CM_updateWorkspacesSchema

Use the CM_updateWorkspacesSchema script when you have made changes to the base schema, and need the workspaces schema updated to reflect those changes.

Usage

• WC_INSTALL/bin/config_ant.sh -buildfile
  WC_INSTALL/components/Workspaces/xml/updateWorkspacesSchema.xml
  -DinstanceName=instance
  -DresourceXMLLocation=location_of_resource_XML_Files
  -DdbaPassword=administrative_password
  -DgenerateSQLStatementsOnly=true|false(optional)
  -DgenerateSQLStatementsOutputFile=outputFileDirectory(optional)
  -DdebugMode=true(optional)
  CM_updateWorkspacesSchema
  -logfile location_of_log_file (optional)
  

• WC_INSTALL/bin/config_ant.bat -buildfile
  WC_INSTALL/components/Workspaces/xml/updateWorkspacesSchema.xml
  -DinstanceName=instance 
  -DresourceXMLLocation=location_of_resource_XML_Files
  -DdbaPassword=administrative_password
  -DgenerateSQLStatementsOnly=true|false(optional)
  -DgenerateSQLStatementsOutputFile=outputFileDirectory(optional)
  -DdebugMode=true(optional)
  CM_updateWorkspacesSchema
  -logfile location_of_log_file (optional)
  

Notes:

• This text is wrapped for display purposes. Enter the command on one line.

• To run the ANT task on a WebSphere Commerce Developer environment, refer to Run the authoring server update scripts on the development environment.

Parameters

instance

The WCS instance name.

resourceXMLLocation

This is the XML directory where the content-management/wc-resource-containers.xml and all the other resource manager XML files reside. The directory only needs to contain the resource manager XML file for this table if the table is content managed or operational. If there is no resource file for a table found in the content-management directory under the specified location, the tool assumes that there is no change to the resource type of the table, or the table is a non-managed type table if the table does not exist in the workspace yet. The tool looks for the a directory named "content-management" under the specified location first. If the tool cannot find the content-management directory under the specified location, it tries to locate the content-management directory under the tools classpath. If the tool still cannot find any content-management directory, it throws an exception. In summary, the content-management directory must exist even if it is empty.

dbaPassword

The password for the database administrative user. This password is needed for schema creation and update.

generateSQLStatementsOnly (optional)

A flag (true or false) to indicate that the Ant task should not actually update the workspaces but rather just report the SQL used to update the workspace pool. The default value is false, which means that the workspace pool will be updated.

generateSQLStatementsOutputFile (optional)

The output file to print the SQL statements to if generateSQLStatementsOnly is set to true. If not specified then the SQL is output to standard output stream.

debugMode (optional)

If true, trace and log information is enabled and prints to file: WC_INSTALL/logs/Application.messages.log

logfile (optional)

If provided, the ANT script will create or overwrite a log file at this location.

+

Search Tips   |   Advanced Search