Troubleshooting WebSphere Commerce Analyzer: Unable to allocate new pages in tablespace
The following DB2 error may occur during the ETL (extract, transform and load) process:
SQL0289N Unable to allocate new pages in table spacetablespace_name.
This error appears because either the tablespace_name's tablespace size is too small or the disk space is depleted.
To correct the problem, first check the cumulative free disk space.
If there is sufficient disk space, alter the tablespace size by doing the following:
- First determine which step failed and details about the error. Refer to the log files in WCA_installdir/logs for more information.
- Locate the name of the table that failed the step by looking in the Warehouse Center.
- Determine the tablespace name using the DB2 Control Center.
- Increase the tablespace size.
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.