Editing the Collect List - 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 Collect List enables you to preview and customize the statistics that a job collects. You can select whether to automatically generate a collect list or use an existing list, and you can prioritize the objects in the list.
  1. From the Jobs tab, do one of the following:
    • Click next to a collect job and click Edit.
    • Click a collect job and then click Actions > Edit.
  2. Click the Collect List tab and select one of the following:
    Option Description
    Automatically generate the collect list
    1. Select if you want COLLECT STATISTICS statements to be automatically ordered according to system-determined and user-specified importance.

      This option is recommended.

    2. Select Preview list to generate a collect list.
    Use the list below for the next collect only
    1. Select if you want to customize the order of COLLECT STATISTICS statements the next time the job is run.

      This option automatically switches to a system-generated collect list after the job runs once. Use this option when you need to temporarily adjust collection priority to favor statistics that need immediate attention.

    2. Select Regenerate list to clear the current collect list and regenerate a new list.
    3. Click Continue.
    Use the list below for all collections
    1. Select if you want to customize the order of COLLECT STATISTICS statements every time the job is run in the future.
    2. Select Regenerate list to clear the current collect list and regenerate a new list.
    3. Click Continue.

    Choosing this option prevents changes made from the Scope tab and in the Edit Collect Settings dialog box from taking effect, because the COLLECT STATISTICS statement has already been generated.

  3. After the collect list is generated, click Close.