|
|
Archives of the TeradataForum
Message Posted: Sat, 28 Feb 2004 @ 19:49:35 GMT
Subj: | | Re: MLoad Error 2644 |
|
From: | | Victor Sokovin |
| And I am facing the following problem while importing data from a big CSV file using Multiload. | |
| "**** 11:51:39 UTY0805 RDBMS failure, 2644: No more room in database CSreporting." | |
| What do we mean by this error and how can it be solved? Can any user make the required changes for this problem or only teradata
administrators can solve this proble? | |
It depends. Sometimes you would get this error in Teradata if only one AMP has run out of space. Usually that would be due to the high
data skew. That's why it might be worth checking the contents of the CSV file. Look at the distribution of the PI "prototypes". Perhaps you will
find a high number of records with the same PI values. If that's indeed the case and your data provider confirms that the data is correct, you'll
need to restructure the PI.
Of course, the error can simply mean that the entire CSreporting database is out of space. A DBA will have to resize it then.
Regards,
Victor
| |