Code = 2644 No more room in database

Tools
Enthusiast

Code = 2644 No more room in database

Hi folks, I need you expert advice once again...

the client is trying to execute a procedure and is getting this error

message Code = 2644.
2644: No more room in database SMB_ETLBASE.
Output directed to Answer set window

I verified the Max Perm space of that database and it's

Database Name Used Max Perm Space % used
SMB_ETLBASE 2,328,576 21,225,428 11

I do not understand why the client would be getting this error message when clearly there is enough room.

Anxiously waiting for a reply...
11 REPLIES
Teradata Employee

Re: Code = 2644 No more room in database

Space is managed on a "per-AMP" basis. If one AMP is out of space, the database is full.

select VProc, CurrentPerm, MaxPerm from dbc.DiskSpace where DatabaseName='SMB_ETLBASE';

Data skew such as this is typically the result of a poor (e.g. defaulted to first column) primary index. To find the offending table(s):

select TableName, sum(CurrentPerm) as ActualSpace,
count(*)*(max(CurrentPerm)-avg(CurrentPerm)) as WastedSpace
from dbc.TableSize where DatabaseName='SMB_ETLBASE'
group by TableName order by WastedSpace desc;
Enthusiast

Re: Code = 2644 No more room in database

drop unwanted tables from the database .
N/A

Re: Code = 2644 No more room in database

???????????Owner????
Enthusiast

Re: Code = 2644 No more room in database

Hi Fred, I ran you suggested script... however how do I interpret the results (see below) are they good, bad, should be investigated ???

select TableName, sum(CurrentPerm) as ActualSpace,
count(*)*(max(CurrentPerm)-avg(CurrentPerm)) as WastedSpace
from dbc.TableSize where DatabaseName='SMB_ETLBASE'
group by TableName order by WastedSpace desc;

Results:
TableName ActualSpace WastedSpace
USP_BUSIP_LD_SUBSCRIBER_SALE 544768 20959232
USP_BUSIP_PURGE_DERIVED_LAYER 366592 12843008
USP_BUSIP_LD_SUBSCRIBER_LOSS 333824 6731776
USP_BUSIP_LD_PROD_METRICS_SALE 258048 5271552
USP_BUSIP_LD_PROD_METRICS_MGRT 258048 5271552
USP_BUSIP_LD_PROD_METRICS_LOSS 260096 5269504
USP_BUSIP_ERR_HNDLR 202752 2562048
USP_BUSIP_INFO_MSG_FORMAT 180224 1202176
USP_BUSIP_VPROCCTL 180224 1202176
USP_BUSIP_LOGGING 178176 1050624
Teradata Employee

Re: Code = 2644 No more room in database

Since your "wasted" space is several orders of magnitude larger than the "actual" space to hold the data, I would consider this bad and worthy of investigation. In particular, review the PI choices.
Enthusiast

Re: Code = 2644 No more room in database

Thks Fred... much appreciated. I will start an investigation
Enthusiast

Re: Code = 2644 No more room in database

Hi
even Im getting the following error in MultiLoad VM Ware edition...I am just trying to update a small table
which is having 21 records

UTY0805 RDBMS failure, 2644: No more room in database personnel.
KVB
Enthusiast

Re: Code = 2644 No more room in database

You can maintain anotehr backup database to hold the tables which were unused for 2 to 3 months and delete from the main database.so that you can able to achive the space in the frequently used database.

New Member

Re: Code = 2644 No more room in database

Hi I am loading a file from Fastload script.

The file was create using fastexport from a Teradata table of 50 column.

Only 8 columns are used in the file creation , rest are '' to go as null. File is Pipe delimited

When i run fast load the table loaded has size two times as of the 1s teradta table( used for creating the file).

What could be the reason for this big size.

thank ,

Abhishek