Question & Answer
Question
Creating a new database and bootstrap data for existing WebSphere Commerce instance *|* -A9E8CAE5797E3A2985257230006A123C- *|*
Answer
Technote (troubleshooting)
Problem(Abstract)
How to create a new database and bootstrap data for existing WebSphere Commerce instance
Cause
Configuration manager in pre-6.0 does not provide functionality to create database for existing WebSphere Commerce instance.
Resolving the problem
An ANT script is supplied with WebSphere Commerce which is able to create database create stored procedures enables the triggers and massloads bootstrap data.
ANT script
http://publib.boulder.ibm.com/infocenter/wchelp/v6r0m0/topic/com.ibm.commerce.admin.doc/concepts/ccmanttargets.htm
To create database refer to ANT target: CreateDatabase
http://publib.boulder.ibm.com/infocenter/wchelp/v6r0m0/topic/com.ibm.commerce.admin.doc/refs/rcmCreateDatabase.htm
It is necessary to prepare an createInstance.properties file.
An example is:
WC_installdir/bin/config_ant.sh -DinstanceName=instanceName -DdbaPassword=dbaPassword -DdbUserPassword=dbUserPassword CreateDatabase
To prepare bootstrap data refer to the ANT target: EnableTriggersAndPopulateSchema
An example is:
WC_installdir/bin/config_ant.sh -DinstanceName=instanceName -DsiteAdminPassword=siteAdminPassword -DmerchantKey=merchantKey -DdbUserPassword=dbUserPassword EnableTriggersAndPopulateSchema
Was this topic helpful?
Document Information
More support for:
Sterling Total Payments for Financial Services
Software version:
All Versions
Document number:
767801
Modified date:
12 October 2021
UID
ibm10767801