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