TDWMSetRulesetAttr Syntax - Teradata VantageCloud Lake

Syntax

REPLACE PROCEDURE TDWM.TDWMSetRulesetAttr 
(  IN RulesetName            TD_ANYTYPE,
   IN NewRulesetName         TD_ANYTYPE,
   IN NewEventInterval	   INTEGER,
   IN NewDashboardInterval   INTEGER,
   IN NewLoggingInterval	 INTEGER,
   IN NewExceptionInterval   INTEGER,
   IN NewFlexActionInterval  INTEGER,
   IN NewBlockerCycles	   VARCHAR(20) CHARACTER SET LATIN,
   IN NewBlockerAction	   VARCHAR(20) CHARACTER SET LATIN,
   IN NewActivationOptions   VARCHAR(20) CHARACTER SET LATIN,
   IN NewTSAutoDecay		 CHAR(1) CHARACTER SET LATIN,
   IN NewAvailAWTDefinition   VARCHAR(20) CHARACTER SET LATIN,
   IN NewOtherOptions		VARCHAR(20) CHARACTER SET LATIN 
) 
  ...

Syntax Elements

RulesetName

Name of the existing ruleset to be updated. Cannot be NULL and the length must be between 1 and 30.

NewRulesetName

Update the name of this ruleset.

• NULL = No change in ruleset name.
• new_ruleset_name = New name for this ruleset. The length must be between 1 and 30. The new name cannot be ‘FirstConfig’ and cannot be the same as an existing ruleset.

NewEventInterval

Update event interval.

• NULL = No change in event interval.
• <integer> = New event interval value in seconds.Valid values are 5, 10, 30, and 60.

NewDashboardInterval

Update dashboard interval.

• NULL = No change in dashboard interval.
• <integer> = New dashboard interval value in seconds must be: At most 600, and a multiple of EventInterval.

NewLoggingInterval

Update logging interval.

• NULL = No change in logging interval.
• <integer> = New logging interval value in seconds must be: Between 60 and 3600, and a multiple of dashboard interval.

NewExceptionInterval

Update exception interval.

• NULL = No change in exception interval.
• <integer> = New exception interval value in seconds. Valid values are from 1 to 3600.

NewFlexActionInterval

Update flex throttle action interval.

• NULL = No change in flex throttle action interval.
• <integer> = New flex throttle interval action value in seconds must be: A multiple of event interval. Less than or equal to 3600.

NewBlockerCycles

Update the number of consecutive exception intervals that the system must identify a delayed request as a blocker before taking the Blocker Action.

• NULL = No change in the number of consecutive cycles.
• OFF = Turn off blocker detection.
• <integer> = New deadlock cycle value. Valid values are from 1 to 3.

NewBlockerAction

Update action on blocker.

• NULL = No change in blocker action.
• LOG = Log an indication that the delayed request is a blocker.
• RELEASE = Release the blocker to run.
• ABORT = Abort the blocker

NewActivationOption

Update activation option value.

• NULL = No change in activation option value.
• F = Activate Filters and Utility Sessions.
• T = Activate System Throttles and Session Control.
• FT = Activate ‘Filters and Utility Sessions’ and ‘System Throttles and Session Control’

NewTSAutoDecay

Update timeshare decay setting.

• NULL = No change in timeshare decay setting.
• E = Enable timeshare decay.
• D = Disable timeshare decay.

NewAvailAWTDefition

Update available AWT definition.

• NULL = No change in available AWT definition.
• WORKNEW = Available AWTs are WORKNEW work type.
• ANY = Available AWTs are in unreserved pool of any work type.

NewOtherOptions

Update other options of a ruleset.

• NULL = No change in other options.
• +<option> = Set the specified option.
• -<option> = Clear the specified option.
• '{+<option> | -<option>} …' = Set and/or clear multiple options

Options

• L - Transaction Locks bypass throttling: Do not delay requests in a transaction after non-access locks are placed within the transaction. This option is the same as the ‘Prevent Mid-Transaction Throttle Delay’ option of Viewpoint Workload Designer
• P - Prioritize the delay queue based on priorities of workloads associated with delayed requests. Clearing this option prioritizes the delay queue based on delayed time of requests.
• X - Enable high MLOADX limit.
• F - Enable Flex Throttle.
• E - Set Flex Throttle in Evaluation mode. Only applicable when Flex Throttle is enabled (‘F’ option).