Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 28 Feb 2004 @ 19:49:35 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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.  


  The error is  


  "**** 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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023