Archives of the TeradataForum

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

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

BG,

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!

Kevin

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