why we use sys_mgmt database in teradata

Database
Enthusiast

why we use sys_mgmt database in teradata

hi,

I am new to Teradata technology.

Can anybody let me know why we use sys_mgmt database in teradata. Is there any specific use of this SYS_MGMT. ??

Can anybody let me know the most used database names and why they use more in teradata ??

Regards,

Deepak Dhabade

2 REPLIES
Enthusiast

Re: why we use sys_mgmt database in teradata

DBC tables have the querylogs and other information if the logging is enabled. SYS_MGMT(PDCRINFO) is the database which holds the historical information for those which are present in DBC. Querying on the database requires access on the many tables in DBC and in order for these to be faster, it is recommended to keep the DBC as lean as possible. Hence data from the DBC is transferred into the corresponding tables on SYS_MGMT. For a detailed list of the databases please refer to the documentation.

Enthusiast

Re: why we use sys_mgmt database in teradata

Thanks krishna for update.