Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 14:00:05 GMT

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

Subj:   Re: Error 2644 - No more room in database
From:   Victor Sokovin

  I am using following query to monitor the space. But today, below query is giving me strange statistics for particular amp.  

Sure. To get this error message it is enough to run out of space on one AMP. Data skew is a typical reason for this. Check 1) the data distribution on the PI columns in the file your are loading; 2) data skew in all the tables in UAXA. As you have already identified the AMP causing the problem I think 2) is the first thing to check.

The remedy is either to add more space to UAXA or rebuild the skewed table(s) using new PI definitions. The latter solution is probably better long-term but you will have to make sure that the new definitions do not create other problems.



  <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