Technote

(FAQ)
Table space error during replication or ETL related to the tablespace size with WebSphere Commerce Analyzer
The following error occurs during replication or ETL :

SQL0289N Unable to allocate new pages in table space "WCA_FACT_EVENT".
Cause
The tablespace size is not sufficient given the amount of data required for storage.


Answer

To increase the tablespace, perform the following steps in the Control Center. Add a greater value in comparison to the previous size (there is no suggested container size as it is based on data). USERSPACE1 in the screen capture is only an example. You must perform the changes for the tablespace identified in the error, WCA_FACT_EVENT.

Restart the database, and try the replication or ETL again.



 

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21247759