Run the authoring server update scripts on the WebSphere Commerce Server

Use the authoring server update scripts to do one of the following tasks:

• Recalibrate a table

• Recalibrate the entire schema

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

• Verify the WebSphere Commerce Server is not running since this tool is updating the workspace schema structure.

• The createInstance.properties file must exist for this Ant script to work. For information on generating the properties file, see Ant targets. The createInstance.properties file contains a complete list of properties. If change any of the property values, you can do this by modifying the createInstance.properties file:

  • AIX|Linux|Solaris|Windows:

    WC_installdir/instances/instance/properties/createInstance.properties 
    
    

  • I5/OS|

    WC_userdir/instances/instance/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.

Recalibrating a single table

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

• AIX|Linux|Solaris|I5/OS|

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

• Windows:

  WC_installdir/bin/config_ant.bat -buildfile
  WC_installdir/components/Workspaces/xml/updateWorkspacesSchemaTable.xml
   -DinstanceName=instance -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: UpdateWorkspacesSchemaTable for usage and parameter information.

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 -DresourceXMLLocation=location_of_resource_XML_Files -DgenerateSQLStatementsOnly=true|false(optional) -DgenerateSQLStatementsOutputFile=outputFileDirectory(optional) -DdebugMode=true(optional) CM_updateWorkspaces

• Windows:

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

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

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

Related Concepts

Authoring server schema update tool
Workspaces
Authoring server

Related tasks

Run the authoring server update scripts on the development environment