increase size of teraData database

Database
Enthusiast

increase size of teraData database

I am using Teradata demo V2R5, when I was installing it, I checked database size 1046, after installation I created a database name “myDWH” permspace 700MB, but when I uploaded data to "myDWH" I faced error that no room in database, when I am increasing size from tool->modify database then I facing error “the request to assign new PERMANEN space is invalid”, allthough i have 10GB space in driver where i installed teraData.
Show me way to increase database size,
7 REPLIES
Teradata Employee

Re: increase size of teraData database

Hello,

Can you please execute the following query on your teradata system and reply back with the output?

SELECT
databasename ,
SUM ((((MaxPerm) / 1024) /1024) / 1024) AS Maximum_Space_GB ,
SUM ((((CurrentPerm) / 1024) /1024) / 1024) AS Current_Space_Used_GB,
((100-Percent_Used)*Maximum_Space_GB)/100 AS Free_Space_GB,
(Current_Space_Used_GB / NULLIFZERO (Maximum_Space_GB) * 100 ) (FORMAT 'zz9.99%' , TITLE 'Percent // Used') AS Percent_Used,
(Free_Space_GB / NULLIFZERO (Maximum_Space_GB))
FROM DBC.DISKSPACE
Group By 1
ORDER BY 5 DESC;

Regards,

Adeel
Enthusiast

Re: increase size of teraData database

database = jehan

max space= 700MB

used = 684MB

free = 16 MB

% used = 97%
Teradata Employee

Re: increase size of teraData database

Thanks for the ultra-trimmed output, but its of no use unless it is exact output of the query...without trimming offcourse!
Senior Apprentice

Re: increase size of teraData database

The Teradata demo version has a fixed size, which can't be increased.

Better use TD12 demo, this one has a size of 4GB.

Dieter
Fan

Re: increase size of teraData database

hi,Dieter

 

The Teradata13.0 Express version,the size has fixed?

 

 

Regards

 

duanxz

Teradata Employee

Re: increase size of teraData database

For the demo version, limit is still 4 GB .... doesnt really makes sense for a demo version to have more than that.

Regards, Adeel

Enthusiast

Re: increase size of teraData database

HI All,

I need to increase DBC space  ? ? I am trying to increase space on in TD Admin GUI ,Tool option -->modify user ,i am trying to increase space,but i am getting error : 

Error is :

The user does not have DROP USER access to database DBC. ....

How can i increase the dbc space ? ?

And my env TD server is running on windows 2003 server ,Version of TD 13.00

Any one help me in this issue ? ?

Thanks in advance

Thanks,

Vasudevarao

8197968610