Example: Classifying a Workload by Query Band - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide
Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
Product Category
Teradata Tools and Utilities
The Include QueryBand and Exclude QueryBand classification options enable requests coming from a single or common logon to be classified into different workloads based on the query band set by the originating application. This enables an application to influence different priorities for different requests. For example, the GUI for an application may have dialogs that require quick responses and other dialogs that submit long running reports that run in the background. The application can set a different query band for each type of job, causing the requests to be classified into different workloads and run at different priorities. Instead of running the entire application in a single workload, the application can execute the requests in different workloads, each with a different priority, enabling better use of system resources.

Query band values with the same name are OR’ed. Query band values with different names are AND’ed.

(NameA=ValA1 OR … OR NameA=ValAn ) AND

(NameB=ValB1 OR … OR NameB=ValBm ) AND

…

(NameX=ValX1 OR … OR NameX=ValXx )

For more on query band usage, see Teradata® Viewpoint User Guide, B035-2206.

For this example, assume that a workload is being created for batch requisition types by north or east regions, but an exception is needed to exclude accounting jobs.

Workload classification criteria cannot be manually modified from the Classification tab of the Workload Attributes window. You can, however, add more classification criteria using the Split option.

  1. Right-click the workload in the list on the left side of the Workload Attributes window.
  2. Click Split from the right-click menu.. The Split Workloads dialog box appears. For details on the fields used for splitting workloads, see Splitting Workloads.
  3. Click Add New Classification. The Classification tab appears, similar to the tab of the same name on the Workload Attributes window, however all functionality is enabled.
  4. Select the Choose another selection criteria check box. The --AND-- pane of the tab becomes visible, showing the Criteria #2 drop-down list. The list includes the items shown as check boxes in the Category pane of the Define DBQL Inputs dialog.
  5. Select Include QueryBand from the Criteria #2 list of the Classification tab. See Defining or Modifying Classification Criteria #2–6 for a WD for more information. The Choose box and button become enabled.
  6. Click Choose. The Include QueryBand dialog box appears.
  7. Select Load Names to display all query band names and for this example, select the Region name. Alternatively, type the value Region in the QueryBand Names box.
  8. Select Load Values to display all query band values, and for this example, select the North values. Alternatively, type the value North in the QueryBand Values box.
  9. Select Add to add the name and value pair.
  10. Repeat steps 7–9 to add a name and value pair for the East region.
  11. When finished, click OK to return to the Classification tab.
  12. Click Cancel to discard your classification selections and start over.
  13. Click the Choose another selection criteria check box. The Criteria drop-down list appears for you to select the next criteria.
  14. Select Exclude QueryBand. Notice that Include QueryBand is no longer an option.

    The Exclude QueryBand dialog box appears.

  15. Repeat the steps used to configure the Include QueryBand dialog box and define the accounting job whose query band you want to exclude.
  16. When finished, select OK to close the dialog box and return to the Classification tab.