Classifying by Excluded Objects for Splitting and Merging Workloads - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

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

This section describes classification by excluded objects for split and merged workloads.

Teradata WA includes an option to limit object exclusion to only requests that include the excluded object type. This option is helpful for “Where” parameters such as Stored Procedures or Macros.

For example, a DBA classifies a request into a workload but only wants a Stored Procedure, and not Stored Procedure ‘A.’ The DBA could specifically exclude non-stored procedure requests to not classify into the workload. Additionally, only stored procedures NOT named Stored Procedure ‘A’ classify to this workload.

For information about splitting workloads, see “To split workloads” on page 135.

For information about how to merge workloads, see “To merge workloads” on page 134.

Classification by Excluding Objects for Workload Splits

For example, in Figure 21, in Workload #2, Crash dumps is included, and Sys_Calendar is excluded under UserName. SysAdmin is included under AccountString.

Figure 21: Split workload with excluded and included objects

After the workload split, the Classification tab for the original workload (WD-test1) displays the following classifications.

Figure 22: Classification tab for original workload after a split

Criteria #1 is Account String, and $H-DBC-MANAGER is included, while $H-remote-console-use and Sys_Calendar are excluded. Criteria #2 is Username, and DBC is included, while EXTUSER is excluded.

The Classification tab for the split workload (WD-test1_sp4) displays the following classifications.

Figure 23: Classification tab for split workload with excluded and included objects

Criteria #1 for the split workload is Account String. It includes SysAdmin. Criteria #2 for the split workload is Username. It includes Crashdumps and excludes Sys_Calendar.

Classification by Excluding Objects for Workload Merges

After a workload is merged together, the Classification tab displays the included and excluded objects in one list for each classification type.

In this example, WD-test1 and WD-test1_sp4 are merged together. The classification for this merge displays on the Classification tab as the following:

Figure 24: Classification tab for merged workload