Troubleshooting WebSphere Commerce Analyzer: The first step in the replication cycle runs for a long time

If the first step in the replication cycle runs for a long time, you may need to rebind the apply program to the data mart database and the WebSphere Commerce database. To rebind the apply program, issue the following at a DB2 command prompt twice, once for the data mart database and once for the WebSphere Commerce database:

db2 terminate
db2 connect to database_name
db2 bind $DB2DIR\bnd\@applycs.lst action replace blocking all grant public 
sqlerror continue
db2 bind $DB2DIR\bnd\@applyur.lst action replace blocking all grant public 
sqlerror continue

where database_name is the name of your data mart database and the name of the WebSphere Commerce database.

Run Replication and ETL again.

See Upgrading your DB2 fix pack level on the WebSphere Commerce Analyzer machine for related troubleshooting information.

Related concepts

• Replication and extract, transform, and load (ETL) processes

Related tasks

• Run replication and ETL

Related reference

• Troubleshooting WebSphere Commerce Analyzer

(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.