Maintaining the WebSphere Commerce Analyzer data mart

The Site Administrator may need to perform maintenance tasks on the data mart. These tasks include:

• Backing up and restoring the data mart
• Remove store data
• Changing the buffer pools, tables, and tablespaces

For performance-related maintenance:

• Reorganizing the data mart tables
• Updating the MAX_SYNCH_MINUTES column

Related concepts

• WebSphere Commerce Analyzer
• WebSphere Commerce Analyzer reports
• WebSphere Commerce Analyzer customization

Related tasks

• Scheduling replication and ETL
• Run replication and ETL

Related reference

• Source and staging tables for WebSphere Commerce Analyzer
• Factors considered when processing rows in a staging table
• WebSphere Commerce Analyzer fiscal calendar properties
• WebSphere Commerce Analyzer flows
• WebSphere Commerce Analyzer parameters
• Troubleshooting WebSphere Commerce Analyzer

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