Data Dictionary

Database
Fan

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?

4 REPLIES
Junior Contributor

Re: Data Dictionary

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).

Fan

Re: Data Dictionary

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

Highlighted
Junior Contributor

Re: Data Dictionary

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.

Fan

Re: Data Dictionary

thanks Dieter for your help. :)