TDWMAddClassificationForTarget Syntax Elements - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248
RulesetName
Name of the ruleset that contains the RuleName. Use 'ALLRULESETS' to indicate all existing rulesets. Cannot be null and its length must be between 1 and 30.
RuleName
Name of the rule to add the criterion. The specified name must be unique among all existing TASM rules: throttles, arrival rate meters, workloads, filters. A combination of RulesetName and RuleName uniquely identifies a specific rule. If RulesetName is 'ALLRULESETS', the criterion is added to the same rule name in all existing rulesets. The name cannot be null. The length must be between 1 and 30.
TargetType and TargetValue
These parameters identify the target to which to add the sub-criterion. The maximum length of TargetValue is 256 characters. A TargetValue may include the following wildcard characters:
  • '*' = Matches zero or more characters
  • '?' = Matches one character

The following table describes possible values for TargetType and TargetValue.

TargetType TargetValue
DB Database name
TABLE Table name
VIEW View name
MACRO Macro name
SPROC Stored procedure name
Description
Description of the criterion.
ClassificationType
Allowable values for ClassificationType depend on the specified TargetType. The following table describes possible values for ClassificationType for each TargetType.MINACCPCT specifies the estimated minimum percentage of the specified table that a request accesses.
  DB TABLE VIEW MACRO SPROC
FTSCAN X X X X X
JOIN X X X X X
MINSTEPROWS X X X X X
MAXSTEPROWS X X X X X
MINSTEPTIME X X X X X
MINACCPCT   X      
STMT
  • D (DDL)
  • M (DML)
  • S (SELECT)
   X      
ClassificationValue
This table describes possible values for ClassificationValue.
Classification Type Classification Value
STMT
  • D = DDL
  • M = DML
  • S = SELECT

Or a combination of the preceding values.
MINSTEPROWS Integer (>= 1) specifying minimum estimated step row count
MAXSTEPROWS Integer (>= 1) specifying maximum estimated step row count
MINSTEPTIME Decimal (>= 0) specifying minimum estimated step processing time
MAXSTEPTIME Decimal (>= 0) specifying maximum estimated step processing time
JOIN Only one of these values is allowed.
  • N = no join
  • A = any join type
  • P = product join
  • Q = no product join
  • U = unconstrained product join
  • V = no unconstrained product join
FTSCAN Not applicable
MINACCPCT Decimal (<= 100) specifying minimum percentage of table being accessed.
ClassificationOperator
If ClassificationType value is FTSCAN, this parameter specifies whether the criterion is for inclusion or exclusion. For all other ClassificationType values of a target, the criterion must be set for inclusion.
  • 'I' = criterion is for inclusion
  • 'E' = criterion is for exclusion
'I' and 'E' are mutually exclusive.
ReplaceOption
  • 'Y' = Delete the all existing sub-criteria of the specified target and add the sub-criterion. If the specified target does not exist or does not have any sub-criteria, an error is returned.
  • 'N' = Add a sub-criterion. If the specified sub-criterion exists, an error is returned.