All Forums Tools
16 Mar 2006
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 windowI verified the Max Perm space of that database and it's Database Name Used Max Perm Space % usedSMB_ETLBASE 2,328,576 21,225,428 11I do not understand why the client would be getting this error message when clearly there is enough room.Anxiously waiting for a reply...

Fred 1096 posts Joined 08/04
17 Mar 2006

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 WastedSpacefrom dbc.TableSize where DatabaseName='SMB_ETLBASE'group by TableName order by WastedSpace desc;

GreatSushant 12 posts Joined 05/05
29 Mar 2006

drop unwanted tables from the database .

nmgmag 1 post Joined 10/07
30 Oct 2007

???????????Owner????

30 Oct 2007

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 WastedSpaceUSP_BUSIP_LD_SUBSCRIBER_SALE 544768 20959232USP_BUSIP_PURGE_DERIVED_LAYER 366592 12843008USP_BUSIP_LD_SUBSCRIBER_LOSS 333824 6731776USP_BUSIP_LD_PROD_METRICS_SALE 258048 5271552USP_BUSIP_LD_PROD_METRICS_MGRT 258048 5271552USP_BUSIP_LD_PROD_METRICS_LOSS 260096 5269504USP_BUSIP_ERR_HNDLR 202752 2562048USP_BUSIP_INFO_MSG_FORMAT 180224 1202176USP_BUSIP_VPROCCTL 180224 1202176USP_BUSIP_LOGGING 178176 1050624

Fred 1096 posts Joined 08/04
30 Oct 2007

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.

30 Oct 2007

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

meta 22 posts Joined 11/09
15 Mar 2010

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 124 posts Joined 09/12
19 Mar 2014

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.

20 Mar 2014

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

abhishek

larun1616 29 posts Joined 09/14
28 Oct 2014

Here, Wasted time space will be released or permanently occupied?

akamlakar 1 post Joined 07/15
17 Apr 2016

Add space to DB
 
 MODIFY DATABASE A AS PERM = 1e9;

You must sign in to leave a comment.