Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: How are stored procedures stored on AMPs.
From:   Bill Grenwelge

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
     order by 3 desc

  <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: 28 Jun 2020