Linux

Updating WebSphere Commerce database settings in a cloned environment

Update the host name of the WebSphere Commerce server and WebSphere Commerce search server if necessary.

Procedure

  1. If the host name of your WebSphere Commerce search server changed, run the following SQL queries against the WebSphere Commerce database to update the location of the search server:
    update SRCHCONF set CONFIG = replace(CONFIG, 'old_hostname', 'new_hostname')
    update SRCHCONFEXT set CONFIG = replace(CONFIG, 'old_hostname', 'new_hostname)
  2. If the host name of your WebSphere Commerce server changed, run the following SQL queries against the WebSphere Commerce database to update the location of the Commerce server:
    Update cseditatt set CONNSPECATTVALUE='new_hostname' where CONNSPECATTNAME='ProductionServer'