 |
 |
Archives of the TeradataForum
Message Posted: Fri, 13 Dec 2002 @ 21:44:28 GMT
| Subj: | | Re: MLOAD Error 2644 - No more room in database |
| |
| From: | | Geoffrey Rommel |
| | UTY0805 RDBMS failure, 2644: No more room in database DEV. | |
| | I was told by my DBA that I have enough room on DEV database. | |
Most likely you are trying to load a table with an ill-chosen primary index and it is getting skewed on one AMP. Your primary index value
should have a large number of distinct values and a small number of rows per value (1 if possible).
| | How you can verify available room in a database? | |
select sum(maxperm), sum(currentperm),
sum(maxperm) - sum(currentperm) as avail
from dbc.diskspace
where databasename = 'DEV';
| |
