Home Page for the TeradataForum

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: 15 Jun 2023