 |
 |
Archives of the TeradataForum
Message Posted: Wed, 25 May 2005 @ 12:38:10 GMT
| Subj: | | Re: Fastload Problem: No room in database |
| |
| From: | | Meade, Cornelius |
A "No more space" condition is pretty explicit and you can usually be sure that it is correct. As to the reasons why you can run into this
when one might not expect to, the most often cause is that rather than running out of space in the database as a whole, you are running out of
space on a particular AMP. Is it possible that all or most of the new data records you are trying to load are hashing to one or a small number of
AMPs rather than being more evenly distributed? Likewise, if the existing data stored in the database is skewed significantly, you still may not
have enough free space on one or more AMPs to handle the new data even if it would hash out across the AMPs fairly evenly. In short, it is likely
you have some skewing going on if you really have the unused space in the database you believe you have.....
Cornelius Meade III
EDS - Consulting Services/BI/CRM
| |
