Archives of the TeradataForum
Message Posted: Tue, 12 Apr 2005 @ 14:06:32 GMT
| 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
where databasename = ''
and tablename = '' <=== This needs to be the name of the
order by 3 desc