Editing Job Functions for Analyze Jobs - 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
PrerequisiteYou must enable DBQL with the STATSUSAGE option (XMLPLAN is optional) before selecting either of the evaluate stats options on the Functions tab.
  1. From the Jobs tab, do one of the following:
    • Click next to an analyze job and click Edit.
    • Click an analyze job and click Actions > Edit.
  2. Click the Functions tab and select one or more of the following options to be performed when this job is run:
    Option Description
    Evaluate stat usage and staleness and find missing stats to collect Select to have Analytics Database evaluate statistics usage and staleness and find missing statistics to collect so they can be displayed in the portlet. The following selections are optional.
    1. Select Require review before applying recommendations if you want to manually approve or reject recommendations.
    2. Select Edit Settings to use DBQL or rule-based analysis options to determine statistics usage and staleness, and find new collection opportunities, and then click OK.
    Evaluate stats to determine if they should be collected or deactivated Select to have Analytics Database evaluate statistics to determine if they should be collected or deactivated. The following selections are optional.
    1. Select Require review before applying recommendations if you want to manually approve or reject recommendations.
    2. Enter a number and specify a frequency if you want to recommend statistics be deactivated when they have been inactive for the specified amount of time.
    Automate existing stats Select to automate existing statistics. The following selections are optional.
    1. Select Require review before applying recommendations if you want to manually approve or reject recommendations.
    2. Select Limit to stats to enable the following options:
      • Select Initially collected within the last to limit to statistics that were initially collected within the specified days, weeks, or months.
      • Select That are actually used to limit to statistics that are actually used.
  3. Click Save.
  4. After the job is run, review the results in the analyze job report.
    • If you selected Evaluate stat usage and staleness and find missing stats to collect , review the results in the Missing , Usage , and Stale tabs.
    • If you selected Evaluate stats to determine if they should be collected or deactivated , review the results in the Deactivate and Reactivate tabs.
    • If you selected Automate existing stats , review the results in the Automate tab.