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