Statistics Integration - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
The Stats Manager portlet works with the Analytics Database and Viewpoint server to help reduce the impact of statistics management. The following describes the major components and how they work together.
Teradata
All analyze and collect job processing and statistics management action processing is done by the Analytics Database. This database also contains the TDStats database used by the Stats Manager portlet.
TDStats
This database contains additional information related to statistics management, such as the statistics that are automated, object scope lists for jobs, collect lists, job reports, and statistic recommendations. The TDStats database is updated when a job runs, a job completes, or when an action, such as automating a statistic, occurs.
Teradata Viewpoint Data Collection Service (DCS)
The DCS takes information from the Analytics Database and stores it in the local cache database for use by the Stats Manager portlet. The DCS is also used for job scheduling and initiating jobs. If the DCS is not running, scheduled jobs will not run.
Local Cache Database
This database contains all information that can be displayed in the Stats Manager portlet. The database is updated when a job completes, when an action such as Automate is performed, or when the Stats Manager collector runs. The local cache database makes data available quickly without impacting the Analytics Database.
Stats Manager portlet
The Stats Manager portlet lets you view the status of statistics, view the status of jobs that analyze and collect statistics, and configure settings for the statistics management process.
Monitored Systems portlet
The Monitored Systems portlet lets you specify the login identifier used for managing statistics, the frequency of data collection from TDStats, and the frequency of data clean up for TDStats.
The following diagram shows how data flows from Analytics Database to the Stats Manager portlet.