17.00 - Example: Creating a TASM Ruleset to Limit SQLE Analytic Function Concurrency - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K
For details about using Teradata Viewpoint portlets, see Teradata® Viewpoint User Guide, B035-2206. Workload Designer is a workload management portlet.
  1. In the Viewpoint Workload Designer portlet, create a ruleset using the following values.
    Field Value
    Name SQLEAnalyticFunctionThrottle
    Description Ruleset - throttle to limit SQLE Analytic functions concurrency to 4
  2. Create a new system throttle using the following values.
    Field Value
    Name CPU and Memory Intensive.
    Description Set concurrency limit 4 for all SQLE Analytic Functions.
    Rule Type Select Collective: one queue for all matched queries.
  3. Set classification criteria for a system throttle using the following values.
    Field Values
    Add Classification Criteria Select Target.
    Target Type Select Function.
    Database Select TD_SYSFNLIB.
    Functions Select and include using the Include button:
    • DECISIONFORESTPREDICT
    • DECISIONTREEPREDICT
    • GLMPREDICT
    • MOVINGAVERAGE
    • NAIVEBAYESPREDICT
    • NGRAMSPLITTER
    • SVMSPARSEPREDICT
    • ATTRIBUTION
    • NPATH
    • PACK
    • SESSIONIZE
    • STRINGSIMILARITY
    • UNPACK
    • ANTISELECT
    Included Functions Due to character length, the NAIVEBAYESTEXTCLASSIFIERPREDICT function is abbreviated using a wildcard: NAIVEBAYESTEXTCLASSIFIERPREDI* and cannot be included from the Functions list. Instead, include it directly.
  4. Add state-specific settings using the following values.
    For this example, we use the value 4.
    Field Values
    Concurrency Limit
    • Select the blank field and type 4.
    • Select Delay.
  5. Activate the ruleset.