Classification by Excluding Objects for Workload Splits - 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

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

Split Workload with Excluded and Included Objects

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

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.

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.