MultiLoad Error: UTY0805 RDBMS failure, 2644: No more room in database personnel.

General
Enthusiast

MultiLoad Error: UTY0805 RDBMS failure, 2644: No more room in database personnel.

Hi

Iam new to Teradata VM Ware 40gb edition. Iam trying to update a small table which is having 21 records and getting an error;

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

but I checked and there is enough space in the database...can any one help me how to handle this error....here is the complete log on this error:

**** 09:55:26 UTY1803 Import processing statistics
. IMPORT 1 Total thus far
. ========= ==============
Candidate records considered:........ 21....... 21
Apply conditions satisfied:.......... 21....... 21
Candidate records not applied:....... 0....... 0
Candidate records rejected:.......... 0....... 0
**** 09:55:26 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 09:55:27 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0 END;
**** 09:55:28 UTY0817 MultiLoad submitting the following request:
INS PERSONNEL.EMPLOYEE_SALARY_RAISE_LOG (LogType, Seq, MLoadSeq)VALUES(130,
1, 30);
**** 09:55:28 UTY0817 MultiLoad submitting the following request:
ET;
========================================================================
= =
= MultiLoad Application Phase =
= =
========================================================================
**** 09:55:28 UTY0817 MultiLoad submitting the following request:
EXEC MLOAD PERSONNEL.EMPLOYEE2;
**** 09:55:28 UTY0805 RDBMS failure, 2644: No more room in database personnel.
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 09:55:30 UTY6215 The restart log table has NOT been dropped.
**** 09:55:30 UTY6212 A successful disconnect was made from the RDBMS.
**** 09:55:30 UTY2410 Total processor time used = '0.54 Seconds'
. Start : 09:55:19 - FRI MAR 05, 2010
. End : 09:55:30 - FRI MAR 05, 2010
. Highest return code encountered = '12'.

3 REPLIES
Enthusiast

Re: MultiLoad Error: UTY0805 RDBMS failure, 2644: No more room in database personnel.

Hi,
I think the problem is in update query.
It is taking lot of spool space and you are getting this error.Instead of update try to do a SELECT and check whether you get the same error.

regards,
Rupesh
Enthusiast

Re: MultiLoad Error: UTY0805 RDBMS failure, 2644: No more room in database personnel.

Hi,

Please check the database spaces where the UV and ET tables are created.Also, check if the default database of the user id logged in has sufficient space left or not.
If need be increase the space and rerun the script without dropping any table(ET,UV,Log table)

Hope this helps..
Enthusiast

Re: MultiLoad Error: UTY0805 RDBMS failure, 2644: No more room in database personnel.

Please check the Assigned Space of the Logged in user...
Do write your comments back...