Archives of the TeradataForum

Message Posted: Tue, 12 Apr 2005 @ 14:06:32 GMT

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

Stored Procedures from what I have been able to see are very skewed on how they are stored. Most seem to only reside on a few amps (1-4) in the ones I have seen created. That may not hold true for all of them. But, in your case if yours is 1mb and the second one is failing to create then it has used all the space up on one amp and the system is seeing that DB as full.

You can use the following query to see how much space on which amp that SP is using.

     select vproc, tablename,  currentperm
     from dbc.tablesize
     where databasename = ''
     and tablename = '' <=== This needs to be the name of the
     Stored
     Procedure
     order by 3 desc

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