3541 The request to assign new PERMANENT space is invalid

Problem:

CREATE DATABASE "PRDLMDMerchandisingPilotT" FROM "PRDLMDMerchandising" AS

            PERMANENT = 21474836480,

            SPOOL = 0,

            TEMPORARY = 0,

            ACCOUNT = '$L$DL&S&D&H',

            NO FALLBACK,

            NO BEFORE JOURNAL,

            NO AFTER JOURNAL;

 

Executed as Single statement.  Failed [3541 : HY000] The request to assign new PERMANENT space is invalid.

Elapsed time = 00:00:00.025

 STATEMENT 1: Create Database failed.

 

Solution:

Either decrease the PERMANENT space in the new database or increase the PERMANENT space in the parent database. Another Option is Create database with 0 Perm space and then move space from DBC or Other database. 

 

Example:

SELECT DatabaseName, SUM(MaxPerm)/1024/1024/1024 as MaxPerm_GB, SUM(CurrentPerm)/1024/1024/1024 CurrentPerm,

            ((SUM (CurrentPerm))/ NULLIFZERO (SUM(MaxPerm)) * 100)

            (FORMAT 'zz9.99%', TITLE 'Percent // Used')

     FROM DBC.DiskSpaceV

             where databasename='PRDLMDMerchandising'

     GROUP BY 1

     ORDER BY 4 DESC;

 

DatabaseName

Max_Perm_GB

Current_Perm

Percent_Used

PRDLMDMerchandising

0.00

0.00

?

 

Here I can see the parent database has 0 Perm space. So, I have done the following steps:

         1. Create the database with 0 perm space

         2. Move Perm Space from DBC or Other database, Here I have move Perm Space to this database from a database named FREE_SPACE


  1. Create the database with 0 perm space

CREATE DATABASE "PRDLMDMerchandisingPilotT" FROM "PRDLMDMerchandising" AS

            PERMANENT = 0,

            SPOOL = 0,

            TEMPORARY = 0,

            ACCOUNT = '$L$DL&S&D&H',

            NO FALLBACK,

            NO BEFORE JOURNAL,

            NO AFTER JOURfreNAL;


   2. Moving Perm Space from a database name “FREE_SPACE” to the newly created database PRDLMDMerchandisingPilotT From Teradata Studio. (Note: We created “FREE_SPACE” database to reserve available perm space so we can move these space to other database when required, this is not a Teradata default database)


Comments