Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 13 Dec 2002 @ 21:44:28 GMT


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


Subj:   Re: MLOAD Error 2644 - No more room in database
 
From:   Geoffrey Rommel

  UTY0805 RDBMS failure, 2644: No more room in database DEV.  


  I was told by my DBA that I have enough room on DEV database.  


Most likely you are trying to load a table with an ill-chosen primary index and it is getting skewed on one AMP. Your primary index value should have a large number of distinct values and a small number of rows per value (1 if possible).


  How you can verify available room in a database?  


select sum(maxperm), sum(currentperm),
sum(maxperm) - sum(currentperm) as avail
from dbc.diskspace
where databasename = 'DEV';



     
  <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: 28 Jun 2020