Chapter 12. Installing, configuring, and running the WebSphere Commerce Analyzer 343
A window similar to that shown in Figure 12-17 is displayed. Click OK. A
data source is created in WebSphere Application Server for the data mart.
.
Figure 12-17 Successful integration of the WCA with WebSphere Commerce
6. Exit the WebSphere Commerce Configuration Manager. Click OK to publish
the changes to the WebSphere Commerce application. This may take a
couple of minutes.
7. For security reasons, the Configuration Manager Server is stopped. Click OK.
8. Restart the WebSphere Commerce server.
9. (Optional task) Using the IBM WebSphere Application Server Admin console,
verify whether the WCA data source is connecting successfully to the WCA
data mart. If the connection is not successful, view the Java virtual machine
(JVM™) logs for troubleshooting to resolve the problem. Otherwise, the WCA
will not be able to retrieve the data from the data mart to view the reports.
12.6 Running the WebSphere Commerce Analyzer
To run the WCA, it is important to ensure that the capture program (ASNCAP) is
running successfully on the WebSphere Commerce machine and that the DB2
database service is running on the Windows services of the WebSphere
Commerce machine and on the WCA machine.
12.6.1 Running the capture program on the WebSphere
Commerce database
To run the capture program on the WebSphere Commerce database, perform
the following tasks:
1. Before starting the capture program, update the configuration in the
WebSphere Commerce database by performing the following tasks:
a. Stop the WebSphere Commerce application from the WebSphere
Application Server Admin console.
344 IBM Sales Center for WebSphere Commerce V6
b. Run the DB2 command-line processor.
c. Run the following command to see the configuration of the WebSphere
Commerce database:
get db config for wc_database_name
d. Verify the LOGRETAIN setting:
Log retain for recovery enabled (LOGRETAIN) = OFF
e. If it is not set to RECOVERY, modify the configuration by running the
following commands:
connect to wc_database_name
update db config using LOGRETAIN RECOVERY
f. Take a backup of the WebSphere Commerce database at this point:
backup db wc_database_name
g. Verify whether you are able to connect to the WebSphere Commerce
database.
2. Open the Windows command prompt and start the capture program:
asncap wc_database_name startmode=cold
3. Start the WebSphere Commerce application from the WebSphere Application
Server Admin console.

Get Deploying and Customizing IBM Sales Center for WebSphere Commerce V6 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.