Database Engine 20 contains log tables in the Data Dictionary that accumulate data, automatically or after certain features are enabled. Because log data grows over time, you must clear older information to avoid using up permanent space. You can also use the data to generate your own performance analysis reports or use a reporting solution from Teradata Support.
| Logs | Description |
|---|---|
| Access Log (DBC.AccLogTbl) | Data collected as defined in a BEGIN LOGGING statement, for each privilege check of an attempted user access of a database object. |
DBQ Logs, such as:
|
Data collected during database query logging (DBQL). |
| Disk space log (DBC.DatabaseSpace) | Data collected automatically on space allocation for databases and tables. |
| Event Log (DBC.EventLog) | Data collected automatically by the system for each user logon event. |
ResUsage Logs, such as:
|
ResUsage tables collect data on system resource usage. You can enable ResUsage data collection and set the collection rate using Teradata Viewpoint data collectors. The collection rate determines how quickly data accumulates and when to clear the logs. |
| SWEvent Log (DBC.SW_Event_Log) | The system automatically inserts rows in response to software errors and system events, for use by Teradata Customer Service. |
TDWM Logs:
|
Logs for workload management functions. |
| Logs that must be cleared manually | |
| In Doubt transaction Log (DBC.InDoubtResLog) | Contains a row for each transaction where completion was in doubt. |