Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 14:09:43 GMT

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

Subj:   Re: Fastload Problem: No room in database
From:   Tewksbury, Kevin


To follow up on some of what you have been told, you can find out if are out of space on specific amp/vproc by running the below SQL and putting in the databasename that is in question. Unfortunately you can not get space per specific table as space is not assigned specifically to a table but at a database level. However this should show you how your data is spread out across the amps/vprocs for the database. If things do not look evenly distributed then your data is definitely skewed. The data being skewed could be any one, or more, of the tables in the database not specifically the table you are trying to load.

     select vproc, maxperm, currentperm
     from dbc.allspace
     where databasename = ''
          and tablename = 'all'
     order by 3 desc

Hope this helps!


  <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