17.00 - 17.05 - Performance Data Collection Portlet Jobs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

The following are the Performance Data Collection jobs that archive log data frequently to history tables created by DIPPDCR.

Job Description
Session Runs every 10 minutes to archive data about user session duration and session counts
Accounting Runs every hour to archive data about AMP usage
Maintenance Runs once a week to check retention values and clean up Data Dictionary logs if needed

The following are the Performance Data Collection jobs that archive Data Dictionary log tables once a day to history tables created by DIPPDCR.

Job What It Archives
Info Tables User information, including profiles, groups, and space owners
Logon/Logoff Data collected automatically by the system for each user logon or logoff
TDWM Logs for workload management functions:
  • DBC.TDWMSummaryLog
  • DBC.TDWMEventLog
  • DBC.TDWMExceptionLog
  • DBC.TDWMEventHistory
DBQL Database query logs, depending on the type of logging you enable
Disk Space Data collected automatically on space allocation for databases and tables
Resource Usage System-level performance data from the DBC.ResUsage tables
Access Log Security data
Statistics No data; this job refreshes statistics on PDCR tables