Mload error: RDBMS failure: 2644, No more room in database abc

Tools & Utilities
Enthusiast

Mload error: RDBMS failure: 2644, No more room in database abc

Hi,

I am getting "No more room in database" error whenever i am trying to run a mload script through unix. i tried running it in different database, still getting same error. Below is the script and log.

SCRIPT:

.LOGTABLE logtable001;

.LOGON tdp3/user2,tyler;

.BEGIN MLOAD TABLES abc;

.LAYOUT abc;

(

.FIELD in_eno integer

.FIELD in_ename varchar(20)

.FILLER in_dno interger

.FIELD in_sal decimal(10,2)

);

.DML LABEL PAYROLL;

insert into abc(eno,ename,dno,sal)

values(:in_eno, :in_ename, :in_dno,:in_sal);

.IMPORT xyz

LAYOUT abc

FORMAT VARtext ' '

APPLY LABEL PAYROLL;

.END MLOAD;

.LOGOFF;

LOG:

0001 .LOGTABLE logtable001;

0002 .LOGON tdp3/user2,tyler;

**** 09:02:37 UTY8400 Teradata Database Release: 13.10.07.28b

**** 09:02:37 UTY8400 Teradata Database Version: 13.10.07.21

**** 09:02:37 UTY8400 Default character set: ASCII                        

**** 09:02:37 UTY8400 Current RDBMS has interval support

**** 09:02:37 UTY8400 Current RDBMS has UDT support

**** 09:02:37 UTY8400 Current RDBMS has TASM support

**** 09:02:37 UTY8400 Maximum supported buffer size: 1M

**** 09:02:37 UTY8400 Data Encryption supported by RDBMS server

**** 09:02:39 UTY1008 RDBMS failure: 2644, No more room in database abc.

**** 09:02:39 UTY2410 Total processor time used = '0.01 Seconds'

     .       Start : 09:02:37 - FRI AUG 29, 2014

     .       End   : 09:02:39 - FRI AUG 29, 2014

     .       Highest return code encountered = '12'.

1 REPLY
Junior Contributor

Re: Mload error: RDBMS failure: 2644, No more room in database abc

Seems like this is failing when the LogTable should be created.

Check the available perm space of abc (on an AMP level, not with a SUM) or qualify it with a different database.