A component of the Teradata Database called the Regulator dynamically executes to fulfill the workload operating rules as defined with the Workload Administrator. Requests submitted to the system are classified into the appropriate workload and managed against that workload’s operating rules, such as throttling, resource priorities, and exception management.
In addition, the Regulator monitors queries as they run to check for exception conditions, and then handles them according the rules defined in the workload definition configuration tables.
A separate database called TDWM is required for Teradata Workload Analyzer. The database contains tables for storing workload definitions and related data. A Database Initialization Program (DIP) script is used to install the TDWM database. For information about using Teradata DIP scripts, see Utilities (B035-1102).