All Forums Database
jehan 12 posts Joined 11/08
10 Nov 2008
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,

Adeel Chaudhry 773 posts Joined 04/08
10 Nov 2008

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.DISKSPACEGroup By 1ORDER BY 5 DESC;Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

jehan 12 posts Joined 11/08
10 Nov 2008

database = jehanmax space= 700MBused = 684MBfree = 16 MB% used = 97%

Adeel Chaudhry 773 posts Joined 04/08
10 Nov 2008

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

-- If you are stuck at something .... consider it an opportunity to think anew.

dnoeth 4628 posts Joined 11/04
10 Nov 2008

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

Dieter

duanxz 2 posts Joined 05/11
15 Oct 2011

hi,Dieter

 

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

 

 

Regards

 

duanxz

Adeel Chaudhry 773 posts Joined 04/08
17 Oct 2011

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

 

Regards, Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

vasu6 12 posts Joined 10/12
09 Apr 2013

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

Thanks,
Vasudeva Rao

You must sign in to leave a comment.