Troubleshooting WebSphere Commerce Analyzer: WebSphere Commerce Analyzer data mart runs out of disk space
If the WebSphere Commerce Analyzer data mart runs out of disk space during db2load, then the target table could be left in load pending status, so you won't be able to query that table. To fix this, after allocating more table space, terminate the load before re-running the step.
To allocate more table space, take action based on whether you are using Database Managed Storage (DMS) or System Managed Storage (SMS):
If you are using DMS:
Use the ALTER TABLESPACE command to add one or more containers to the tablespace that is full. To accommodate quickly growing data, add a very large container or add more than one container. A container can be files, raw devices, or logical volumes or partitions. After the new containers are added, the data is rebalanced across all the containers. During rebalancing, you can still access the data.
If you are using SMS:
If the hard disk is full, move the data mart to a larger hard disk by doing the following:
- Back up the data mart by archiving the existing data.
- Use a redirected restore to restore the data onto a larger hard disk.
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.