| Juergen Sautter 2004-01-19, 2:48 pm |
| Hi,
the following are instructions if you wanna separate your local installed
WCS database to a remote machine.
1.) Install DB on your remote machine .
2.) Do an export of your local database and import it to the remote
database.
3.) edit AppServer\bin\admin.conf and change the values for the DB.
# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=COM.ibm.db2.jdbc.DB2Connect
ionPoolDataSource
com.ibm.ejs.sm.adminServer.dbserverName=
com.ibm.ejs.sm.adminServer.dbportNumber=
com.ibm.ejs.sm.adminServer.dbdatabaseName=was40
com.ibm.ejs.sm.adminServer.dbuser=commerce
com.ibm.ejs.sm.adminServer.dbpassword={xor}sadsdasdasd=
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true
4.) edit the CommerceServer\instances\<instancename>\xml\<instancename>.xml
file and change there the values for the DB
<Database>
<DB DBAHomeDir=""
DBAName="commerce"
DBAPwd="7W/5="
DBHost="my.host.de"
DBMSName="DB2"
DBNode="mall"
DBServerPort=""
DBUserHomeDir=""
DBUserID="commerce"
DBUserPwd="7W/5P3G4TiRYQngfZIqmfg=="
OraUserID=""
RemoteDB="true"
RunDB2SG="true"
ServiceName=""
StagingEnable="false"
active="true"
name="mall" />
</Database>
ensure you set the RemoteDB to true.
5.) Start WAS and change the WCS DataSource in the WAS Admin console to
point to the remote database.
6.) Start your WCS.
Gratz to me and everybody else who helped me before
Juergen
|