TDWM.WorkloadPlanEnvV Syntax - Teradata VantageCloud Lake

REPLACE VIEW TDWM.WorkloadPlanEnvV
  (RulesetName,
   WorkloadId,
   WorkloadName, 
   PlannedEnvironment, 
   WorkloadEvalOrder,
   WorkloadType, 
   HoldRespTime,
   ServiceLevelGoal, 
   SLGAllocation, 
   SLGCPULimit, 
   SLGIOLimit, 
   OtherOption  
   )  AS
SELECT 
   ...

Syntax Elements

RulesetName

Ruleset name.

WorkloadId

Workload ID.

WorkloadName

Workload name.

PlannedEnvironment

Planned environment name.

WorkloadEvalOrder

Evaluation order of a workload.

WorkloadType

Workload type. Possible values:

• 'Tactical': Tactical
• 'SLG1': SLG Tier 1
• 'SLG2': SLG Tier 2
• 'SLG3': SLG Tier 3
• 'SLG4': SLG Tier 4
• 'SLG5': SLG Tier 5
• 'TSTop': Timeshare top
• 'TSHigh': Timeshare high
• 'TSMed': Timeshare medium
• 'TSLow': Timeshare low

HoldRespTime

Hold response time.

• NONE: No hold response time.
• DEFAULT: Use default Always planned environment setting.
• 'decimal': Hold response time in seconds.

ServiceLevelGoal

Service level goal (SLG) of the workload.

• NONE: No SLG
• DEFAULT: Use default Always planned environment setting.
• '<integer>% @ <decimal> seconds'

  For example, '90% @ 2 seconds' means response time of 2 seconds and service percent of 90%.

• '<integer> rph': Throughput SLG as number of requests per hour.

SLGAllocation

Resource allocation of an SLG workload.

• NULL: No SLG allocation.
• 'decimal' : Resource allocation percentage for an SLG workload.

SLGCPULimit

CPU limit of an SLG workload.

• NONE: No SLG CPU limit.
• '<decimal>' : CPU percentage limit for an SLG workload.

SLGIOLimit

I/O limit of an SLG workload.

• NONE: No SLG I/O limit.
• '<decimal>' : I/O percentage limit for an SLG workload.

OtherOption

Other workload option. Currently, only one option is supported for SLG Tier 1 WD.

• '+Expedited': Use expedited AWT if the workload is SLG Tier 1.

  '-Expedited': Do not use expedited AWT if the workload is SLG Tier 1.