Collect Statistics | Teradata Viewpoint - 17.10 - Collecting Statistics - Teradata Viewpoint

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Viewpoint
Release Number
17.10
Release Date
October 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-2207-101K
Language
English (United States)
When a Stats Manager collect job runs, statistics are collected by TDStats.RunCollect XSP. If the TDStats database does not have permission to collect statistics as an object in the scope of a collect job, the statistics are not collected and an error is reported. Follow this step to prevent these errors.
  1. To grant TDStats permission to collect statistics on any databases you associate with a collect job enter the following:
    GRANT STATISTICS ON DATABASE TO TDStats;