Performance Data Collection Portlet Jobs - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

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