All Forums Database
AMIT@TD 3 posts Joined 11/15
18 Jul 2016
Data Dictionary

Hello Guys
i am new to td. i want to know about DD.
Q1:- can we increase data Dictionary size ?
Q2:- if we can not increase then what is a ratio of data Dictionary space to total teradata space?
Q3:-if we can increase size then how?

dnoeth 4628 posts Joined 11/04
19 Jul 2016

There's no need to increase the Data Dictionary size.
Teradata's DD are the tables located in dbc and there's usually a large perm space assigned to it (it also includes the Transient Journal).

Dieter

AMIT@TD 3 posts Joined 11/15
20 Jul 2016

Thanks dnoeth. please eleborate Q2. and if space is more then why do we bother to save data dictionary space.??

dnoeth 4628 posts Joined 11/04
20 Jul 2016

The size of the actual Data Dictionary tables (excluding TransientJournal, AccessLog, QueryLog, ResUsage) is way less than 1% of the system's perm space.
Best practices recommend to reduce the number of access rights and move the logs daily to a history database.
 

Dieter

AMIT@TD 3 posts Joined 11/15
20 Jul 2016

thanks Dieter for your help. :) 

You must sign in to leave a comment.