If you look closely at the Classification tab of the Workload Attributes window (see Defining or Modifying a Classification Criteria #1 for a WD), you’ll find that some of its options are not enabled. In particular, you cannot use the tab to add more classification criteria.
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 as described in this topic.
- Right-click the workload in the list on the left side of the Workload Attributes window.
- 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.
- 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.
-
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 and the items described below.
Classification Options for Criteria #2 Selected Item Also select... Data Objects Data objects to include and exclude in the Classify by Data Objects dialog box that appears after selecting Data Objects and clicking the Choose button. The following data objects can be selected:- database
- table
- view
- macro
- stored procedure
- function
- method
In the Classify by Data Object dialog box, select objects to include or exclude, and select the type of object to add to the criteria. Load the objects and choose the specific object by selecting it and clicking the Add button. For more information, see Example: Classifying a Workload by Data Object.
Statement Type The statement types you want by selecting the appropriate check boxes. Utility Type The name of the utility (FastLoad, FastExport, MultiLoad, all three, or Archive/Restore) that you want to control in the list box. Teradata WA utility rules apply to FastLoad, MultiLoad, FastExport, TPT Load/Update/Export operator, JDBC FastLoad, and ARCMAIN. Teradata WA classifies the first utility-specific SQL request from a utility job into a WD. All subsequent requests for the utility job run under the same WD (priority).
AMP Limits The check box for Include single or few AMP queries only if appropriate. Selecting this check box causes the workload to accept only queries that are not all-AMP queries. If AMP Limits is selected but this check box is left cleared, no AMP limit is defined and an error message appears because the classification data is missing for this criteria.Row Count Either the Minimum Rows or the Maximum Rows check box or both and type the corresponding values as appropriate. Final Row Count Either the Minimum Final Rows or the Maximum Final Rows check box or both, and type the corresponding values, as appropriate. Estimated Processing Time Either the Minimum Time or Maximum Time by selecting the appropriate check box and specifying the CPU limits for each. You can specify CPU time in hundredths of a second (using the format HHH:MM:SS.dd). Join Type Types of joins to include, including: - All Joins
- No Joins
- All Product Joins
- No Product Joins
- All Unconstrained Product Joins
- No Unconstrained Product Joins
Datablock Selectivity DB selectivity access IPE - Not an IPE
- IPE with Dynamic or Static
Memory Usage - Increased
- Large
- Very Large
Maximum Step Time Maximum Time (maximum time to take for the step) - Select the desired classification criteria for the selected workload from the Criteria #2 drop-down list. For examples of how to proceed, see the following:
- To select an additional criteria for the selected workload, repeat step 5. You can specify a total of six classification criteria.
- When criteria selections are complete, click OK.
-
Select Show to display a report of all WD classification settings.
The Classification Description dialog box appears, showing all workload classification criteria.
- To close the dialog box without saving, click OK.
- To save or print the information in the dialog box, click Save or Print. The standard Windows Save or Print dialog box appears.
-
To view the information in the Classification Description dialog box in plain text, click Plain Text.
The plain text version of the Classification Description dialog box appears.
- To save or print the information in the dialog box, click Save or Print.