Updating the MAX_SYNCH_MINUTES column

If the amount of new data every day is very large (for example, more than 1,000,000 records), use the following information to update the size of the data block used. You can also update the size of the data block when the log fills up.

To update the value, type the following commands at the command prompt:

db2 connect to wca_datamart_name 
db2 update asn.ibmsnap_subs_set  set  max_synch_minutes =  number_of_minutes
db2 connect reset

Where:

wca_datamart_name

This parameter provides the name of the WebSphere Commerce Analyzer data mart.

number_of_minutes

This parameter specifies a value that you choose for the number of minutes. Start with 60 minutes and adjust the value if necessary to improve performance.

For example:

db2 connect to wcamart
db2 update  asn.ibmsnap_subs_set  set  max_synch_minutes =  60
db2 connect reset

For more information see the SQL Replication Guide and Reference for DB2 8.2, available at ftp://ftp.software.ibm.com/ps/products/db2/info/vr82/pdf/en_US/db2e0e82.pdf

Related concepts

Related tasks

Related reference

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