Changing the buffer pools, tables, and table spaces
During the configuration of WebSphere Commerce Analyzer, the data mart is set up with pre-defined buffer pools, tables, and table spaces. This step is documented in the Configuring WebSphere Commerce Analyzer section of the WebSphere Commerce Additional Software Guide.
To change the buffer pools, tables and table spaces of an existing data mart, use the tools in the DB2 Control Center. You can find more information about this topic in the DB2 Information Center. Search for the information about buffer pools, tables, or table spaces.
To recreate your data mart you can configure WebSphere Commerce Analyzer again, as described in Configuring WebSphere Commerce Analyzer section of the WebSphere Commerce Additional Software Guide.
Important: The recommended table space is 400 MB each. However, if the ETL process fails due to less table space page size, the Database Administrator should increase the table space before starting the replication. The following is the list of table spaces and index table spaces:
Data mart Database Table space Index Table space Table space page size WCA WCA_MEMBER WCA_MEMBER_IDX 400 MB WCA_ADDRESS WCA_ADDRESS_IDX 400 MB WCA_FACT_EVENT WCA_FACT_EVENT_IDX 1 GB WCA_ORDERITEM WCA_ORDERITEM_IDX 400 MB WCA_ORDERS WCA_ORDERS_IDX 400 MB WCA.PRODUCT_ATTRIBUTE WCA.PRODUCT_ATTRIBUTE_IDX 400 MB TWSA WSA_DATA 400 MB WSA_IDX WCA_IDX1 400 MB WSA_SESS WSA_SESS_FACTS_IDX 400 MB WSA_SESS_FACTS 400 MB WSA_HIT_FACTS 400 MB (C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.