16.20.16.20 - 16.20 - Creating an Analyze Job - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
You must enable Teradata Database query logging features before selecting either of the evaluate stats options on the Functions tab.
  1. From the Jobs tab, click Actions > New Analyze Job.
  2. Enter a job name, up to 30 alphanumeric characters. The name cannot be the same as an existing job name.
  3. From the Scope tab, click one of the following to specify the objects that will be analyzed by this job:
    Option Description
    All objects Select to analyze all objects across the entire system.
    Existing object list Select to analyze statistics using an existing list that was created for other jobs. Object lists that were externally created outside of the portlet display first.
    Custom object list Select to analyze statistics using a custom object list.
    1. Click Edit list to customize the object list.
    2. From the Objects tab, select to display Automated objects or All objects. Then use the object browser to either select databases to include all related objects in those databases or select individual objects within those databases.
    3. From the Wildcards tab, use wildcard patterns to add objects to the job scope. Click Add Patterns to take the filter combinations you entered in the filter boxes and create a wildcard in the Wildcard Patterns pane.
    4. Click OK.
  4. 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 Teradata Database evaluate statistics usage and staleness and find missing statistics to collect. Do any of the following:
    • [Optional] Select Require review before applying recommendations if you want to manually approve or reject recommendations.
    • Select Edit Settings to use DBQL (default) or rule-based analysis options to determine statistics usage and staleness, and find new collection opportunities, and then click OK. With DBQL, advanced options allow you to limit the queries to a specific user, application, account string, or query band. You can also override the global query log analysis time limit.
    Evaluate stats to determine if they should be collected or deactivated Select to have Teradata Database evaluate statistics to determine if they should be collected or deactivated. Do any of the following:
    • [Optional] Select Require review before applying recommendations if you want to manually approve or reject recommendations.
    • Accept the default value or enter a different number to specify a frequency to recommend statistics be deactivated when they have been inactive for the specified amount of time.
    Automate existing stats [Optional] Select to automate existing statistics. Do any of the following:
    • Select Require review before applying recommendations if you want to manually approve or reject recommendations.
    • 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.
  5. Click the Schedule tab and do one of the following:
    • Click Add Schedule to add a new schedule.
    • Select an existing schedule to edit.
    1. Click OK.
  6. Click Save. The job appears in the list on the Jobs tab.
  7. 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.