Steps To Be Followed For Db2 Configuration

Steps to be followed for configuring WCD 6.0 to point to DB2 GDO database: 1. The most important first step is to take a backup of “workspace” folder which is present under the WCD installation directory. Note: This is a pre caution step so that if WCD 6.0 studio did not start due to some error, the “workspace” folder can be copied from the backup directory and the WCD 6.0 studio will work. 2. Exit from IBM RAD 6.0 screens and ensure that WCD server is not running.

3. Install the DB2 Client software in local machine. Note down the home directory for DB2 Client software installation in local machine.

4. Execute the following commands: 5. Start -> Run -> db2cmd

6. The command in Step 5 will show the command window. Navigate to the “bin” folder under the WCD installation directory. e.g. D:\IBM\WCToolkitEE60\bin

7. D:\IBM\WCToolkitEE60\bin>db2 "catalog tcpip node wcsnode remote 10.143.4.153 server 50005" Execute the above command. 8. D:\IBM\WCToolkitEE60\bin>db2 "catalog database orderdb at node wcsnode" “orderdb” is the database name for Order database. Replace the name “orderdb” with corresponding database name for Member or Catalog database. Execute the above command. 9. D:\IBM\WCToolkitEE60\bin>setdbtype db2 C:\DB2Client\SQLLIB orderdb devinst dev@123 order order@123 10.143.4.153 50005 wcsnode "C:\DB2Client\SQLLIB" in the above command is the HOME directory for DB2 Client software installed in the local machine. “orderdb” is the database name for Order database. Replace the name “orderdb” with corresponding database name for Member or Catalog database. "order" & “order@123” in the above command are username & password for the Order database. Replace with corresponding username and password for Member or Catalog database.

Execute the above command. 10. Start the WCS 6.0 Server. Look at the Console window when server is getting started. No error should be displayed in the console or No red lines should come in the console. 11. The WCS 6.0 is now configured to use the DB2 GDO database. Note: (i)

If you have already started developing a use case before configuring the database as shown above, you need to update the Struts config registry again, insert the required entries to “CMDREG” table and load the Access Control policy XML files again.

(ii)

Sample commands for loading the Access Control policy XML files: D:\IBM\WCToolkitEE60\bin>acpload orderdb order order@123 CreateLabelViewACPolicy.xml order D:\IBM\WCToolkitEE60\bin>acpload orderdb order order@123 CreateLabelControllerCmdACPolicy.xml order The above commands are shown for Order database.

(iii)

Store model: Advanced B2B Direct Store model Store ID: 10701