Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 Dec 2002 @ 21:54:43 GMT

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

Subj:   Re: MLOAD Error 2644 - No more room in database
From:   Fred W Pluebell

Two comments:

1) Teradata space management is by AMP VProc, not total. You can check space using dbc.DiskSpace view, and comparing CurrentPerm with MaxPerm. For example:

SELECT SUM(CurrentPerm) as CurrentSpace,
SUM(MaxPerm) as TotalLimit,
MAX(CurrentPerm) as MaxAMP,
MAX(MaxPerm) as LimitByAMP
FROM dbc.DiskSpace WHERE DatabaseName='DEV';

2) By chance are your worktables and/or errortables (or maybe even the logtable) being placed in a database other than DEV? The error message may be confusing because it names the database that contains the target table, even if the space problem is with one of the other tables in some other database. (DR62635)

  <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