Grouping Unassigned Requests Into a Workload - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities

Grouping Unassigned Requests Into a Workload

You can group unassigned requests such as accounts, applications, users, or profiles into a new workload.

To group unassigned requests into a workload

1 From the Unassigned Requests report panel, press Ctrl and click the rows to be grouped into a workload.

2 Right-click to display shortcut menu.

The options for the Unassigned Requests report shortcut menu are described in the table.

 

Option

Submenu option

Description

Add To

New Workload

Select a single row or block of rows from the Unassigned Requests report and select this option to create a new workload and add all the selected unassigned accounts, applications, or users to the workload.

Existing Workload

Select a single row or block of rows from the Unassigned Requests report and click this option to assign these clusters to an already defined workload.

Auto-Generate Workloads

 

Automatically generates single, new workloads from the rows in the Unassigned Requests report that contain the “who” criteria.

Add Workload Using WildCard

 

Click this option to open the Select WildCard dialog box to assign these clusters with wild card filters.

Save Report As

 

Saves the Unassigned Requests report to a file in .xml, .txt, or .html format.

Print Report

 

Prints the Unassigned Requests report.

Show/Hide Details

 

Hides or displays all unassigned requests under OTHERS row, in case the Top N value selected is greater than the N requests found in the database. If not, this option is unavailable.

3 Click Add To, then click New Workload.

The Add Workload dialog box appears.

4 From the Add Workload dialog box, complete the options as appropriate for the new workload. See the following table.

Note: If there are more than 250 workloads, the Add Workload dialog box becomes unavailable.

 

Option

Description

Name

The name of the workload.

Description

A description of the workload.

Enforcement Priority

  • Tactical - short queries with a fixed response-time requirement.
  • Priority - important queries that should get extra resources.
  • Normal - normal queries; this is the default.
  • Background - low-priority queries with no response time requirement.
  • 5 Click OK.

    The newly created workload now displays in the Workloads Report section of the Candidate Workload Report window.

    For information on creating individual workloads for each unassigned request row, see “Creating a Separate New Workload for Each Selected Row” on page 57.

    To group unassigned requests into an existing workload

    1 From the Unassigned Requests report panel, press Ctrl and click the rows to be grouped into an existing workload.

    2 Right-click to display shortcut menu.

    3 Click Add To, then click Existing Workload.

    The Select Workload dialog box appears.

    4 Select the workload you want to add the unassigned requests to. Click OK.

    5 The selected unassigned requests are grouped with the existing workload and are removed from the Unassigned requests report.

    To create a separate new workload for each selected unassigned request

    1 Select one or more rows in the Unassigned requests report.

    2 Right-click to display the shortcut-menu.

    3 Select Auto-Generate Workloads.

    The Auto-Generate Workloads dialog box appears. For more information, see the Auto-Generate Workloads dialog box options in To create a separate new workload for each selected row and see step 5.

    4 Select the options.

    5 Click OK.

    Teradata WA creates a new workload for each unassigned row containing the Criteria #1 attributes.

    To create a workload from wild card filters

    A workload can be created from wild card filters for quick specification of classifications.

    1 Right-click in the Unassigned requests report. The shortcut-menu displays.

    2 Select Add Workload using wild card. The Select Wildcard dialog box displays.

    3 The options for the Select WildCard dialog box are described in the table below.

     

    Option

    Description

    WildCard Name

    Enter the name of the wild card, with one of the following supported wild card symbols:

  • Asterisk (*) - use the asterisk symbol to represent a missing character. For example, if you enter $M* as your search term, your results might return $M$abc, $M$def, and so forth.
  • Question mark ( ?) - use the question mark symbol to represent one unknown character. Use it when you have a list of similar names, or are unsure of a few characters.
  • Selected WildCard List

    Displays the list of wild cards created.

    Add to New Workload

    Click to add the selected row to a new workload.

    Auto-Generate Workload

    Click to automatically generate a new workload from the selected row.

    4 Type the wild card name in the WildCard Name text box and click >>. The wild card name displays in the Selected Wild Card List list, and results of the wild card search display in the report below.

    5 Select the row in the report and click Add to New Workload. See the table in step 4 of “Grouping Unassigned Requests Into a Workload” on page 44 to complete the options for this dialog box.

    6 To auto-generate the selected row, click Auto-Generate Workload. See step 3 in “To create a separate new workload for each selected row” on page 57 to complete the options for this dialog box.

    The newly created workload displays in the Workload Report.