Running the authoring server update scripts on the WebSphere Commerce Server

Before you begin

When running the config_ant scripts make sure that you have met the following conditions:

Ensure that the WebSphere Commerce Server is not running, as this tool is updating the workspace schema structure.
The createInstance.properties file must exist for this Ant script to work. For information about generating the properties file, see Ant targets. The createInstance.properties file contains a complete list of properties. If you need to change any of the property values, you can do this by modifying the createInstance.properties file:
- ```
WC_installdir/instances/instance_name/properties/createInstance.properties 
```
- ```
WC_userdir/instances/instance_name/properties/createInstance.properties
```
Run the config_ant tool under the WC_installdir/bin directory.
Do not run the config_ant tool under any db2cmd prompt in Windows.

Procedure

Recalibrating a single table:

If you have changed a table in the base schema, run the following script to recalibrate the table:


WC_installdir/bin/config_ant.sh -buildfile
WC_installdir/components/Workspaces/xml/updateWorkspacesSchemaTable.xml
-DinstanceName=instance_name
-DdbaPassword=administrative_password
-DtableName=tableName
-DtableResourceType=tableResourceType(optional)
-DresourceXMLLocation=location_of_resource_XML_Files(optional)
-DgenerateSQLStatementsOnly=true|false(optional)
-DgenerateSQLStatementsOutputFile=outputFileDirectory(optional)
-DdebugMode=true(optional) CM_updateWorkspacesTable


WC_installdir/bin/config_ant.bat -buildfile
WC_installdir/components/Workspaces/xml/updateWorkspacesSchemaTable.xml
-DinstanceName=instance_name
-DdbaPassword=administrative_password
-DtableName=tableName
-DtableResourceType=tableResourceType(optional)
-DresourceXMLLocation=location_of_resource_XML_Files(optional)
-DgenerateSQLStatementsOnly=true|false(optional)
-DgenerateSQLStatementsOutputFile=outputFileDirectory(optional)
-DdebugMode=true(optional) CM_updateWorkspacesTable

This Ant script takes a single table from the base schema and updates the table in the workspaces. See Ant task: CM_updateWorkspacesTable for usage and parameter information.

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

Recalibrating the entire schema:

If you have made many changes in the base schema and want the workspaces schema to reflect those changes, run the following script to recalibrate the entire schema:

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

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

This Ant script scans through the base schema and adjusts the workspaces schema accordingly. See Ant task: CM_updateWorkspacesSchema for usage and parameter information.

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