Classifying by Excluded Objects for Splitting and Merging Workloads
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 124.
For information about how to merge workloads, see “To merge workloads” on page 123.
Classification by Excluding Objects for Workload Splits
For example, in Figure 3, in Workload #2, Crash dumps is included, and Sys_Calendar is excluded under UserName. SysAdmin is included under AccountString.Figure 3: 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 4: 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 5: 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 6: Classification tab for merged workload