How to configure your WebSphere Commerce instance to point to a new database (DB2)​

   Refer: http://www-01.ibm.com/support/docview.wss?uid=swg21252738

   

•  Make a backup of this file:
  /opt/IBM/WebSphere/CommerceServer70/instances/comm01/xml <instanceName>.xml
  and save it as
  /opt/IBM/WebSphere/CommerceServer70/instances/comm01/xml <instanceName>.xml.original​
• Edit the DB name key in your <instanceName>.xml (comm01​.xml):
   <Database>
        <DB DBAHomeDir=""
            DBAName=""
            DBAPwd=""
            DBHost="myhost.ibm.com"
            DBMSName="DB2"
            DBNode="mynode"
            DBServerPort=""
            DBUserHomeDir=""
            DBUserID="myuserid"
            DBUserPwd="Minsq+r9JqRrQSWb4dmuWQ=="
            DefaultLang=""
            JDBCDriverType="native"
            OraUserID=""
            RemoteDB="false"
            RunDB2SG="false"
            ServiceName=""
            StagingEnable="false"
            active="true"
            name="MyDBName" />
      </Database>
• Save your changes.

         

• Stop and restart your servers. 
• After above step we need to update EAR as per below notes.

               http://pic.dhe.ibm.com/infocenter/wchelp/v6r0m0/index.jsp?topic=%2Fcom.ibm.commerce.admin.doc%2Fconcepts%2Fccmxml.htm

               http://pic.dhe.ibm.com/infocenter/wchelp/v6r0m0/index.jsp?topic=%2Fcom.ibm.commerce.admin.doc%2Frefs%2FrcmUpdateEAR.htm​

          /opt/IBM/WebSphere/CommerceServer70/bin

          [wasadmin@nrnlx447 bin]$ ./config_ant.sh -DinstanceName=comm01 UpdateEAR

     

     This should update wc-server.xml file but didn't work so has to update it manually as mentioned in next step.

• • Go to was admin console and update database connections manually.

         ​Resources > JDBC > JDBC providers
  
          
  

  

  
  
         Click on WebSphere Commerce Search DB2 JDBC Provider comm01 > Click DataSources under Additional Properties.
         
  

  

  
           Again click on WebSphere Commerce Search DB2 DataSource comm01 from the datasources list > Configuration Page will be opened
           Edit the DB nodes to desired values, apply and save.
  
  
  
         
           Repeat this for rest of the JDBC providers for comm01.
           Restart server.