Teradata dynamic workload management software, a key component of Teradata Active System Management (TASM), is a rule-oriented management system capable of detecting and acting on events.
Teradata ASM is not fully supported on Teradata appliances. For more information, see appropriate appliance documents for further details.
Teradata Dynamic Workload Management APIs allow database administrators to:
- Monitor delayed requests
- Release or stop requests from the delay queue
- Display the workload definition of a query
- Determine the current status of TASM rules and rule sets
- Review statistics on how TASM rule categories are affecting request processing
- Retrieve information about the current status of all event-related constructs
- Enable or disable user-defined events for event management
For examples on performing these Teradata Dynamic Workload Management functions, see the following examples.
Examples Using Open APIs
The following table describes the different uses of the Teradata Dynamic Workload Management open APIs.
| Functions | Usage |
|---|---|
|
Change the workload to WD-Report-High of all active requests with a workload of WD-Report-Low. |
| TDWMEventControl | Change the active health condition or planned environment on the system to adjust the throttles. |
| TDWMEventStatus | Display all active events. |
|
Release all delayed queries for a specified workload. |
| TDWMRuleControl function | Temporarily enable a rule to block an application for accessing a database while it is synchronized between two active systems. |
| TDWMSummary function | Display the current workload summary statistics. |
| TDWMThrottleStatistics function | Display the current delay queue statistics. |
Functionality
The following table describes the interfaces of the Teradata Dynamic Workload Management that are used to return WDs, delayed query lists, summary data, and statistics; and update the components stored in the Teradata Dynamic Workload Management database.
The updates in the TDWMRuleControl and TDWMSetLimits procedures must be committed before the TDWMApply procedure can be called. If the same transaction is used to call the external stored procedures that update the TDWM database and the TDWMApply external stored procedure, a self-deadlock occurs, as in the following example.
Bt; Call TDWMRuleControl()
The updates are not committed because the TDWMRuleControl procedure is in a transaction (that is, the rows are locked for write).
Call TDWMApply(200, 'Y','N','N','N');
The TDWM database waits on the locked tables.
| Goal | SQL Interface to Use | CLIv2 or Teradata JDBC Driver Request to Use |
|---|---|---|
| Abort a request or utility session on the Teradata dynamic workload management software delay queue | TDWMAbortDelayedRequest | TDWM DELAY REQUEST CHANGE |
| Apply changes to the rules in one or more the Teradata dynamic workload management software categories | TDWMApply | — |
| Change the workload a session or request is assigned to | TDWMAssignWD | TDWM WD ASSIGNMENT |
| Activate or deactivate a user-defined event | TDWMEventControl | USER EVENT CONTROL |
| List all objects that make up the system state | TDWMEventMapping | EVENT STATUS |
| Return the defined events | TDWMEventStatus | EVENT STATUS |
| Return the collection rate (that is, the first record of the Teradata dynamic workload management software Exception PM/API request) or return Teradata dynamic workload management software exception data from the database | TDWMExceptionRate | TDWM EXCEPTIONS |
| Collect the Teradata dynamic workload management software exception data from the database | TDWMExceptions | TDWM EXCEPTIONS |
| Report if each category is active or not | TDWMInquire | — |
| Return the delayed query data fields and delay information | TDWMGetDelayedQueries | TDWM STATISTICS |
| Return the utility delay queue | TDWMGetDelayedUtilities | TDWM STATISTICS |
| Return a list of the WDs | TDWMListWDs | TDWM LIST WD |
| Return the statistics on the load utilities that are available in the system | TDWMLoadUtilStatistics | TDWM STATISTICS |
| Release a request or utility session on the Teradata dynamic workload management software delay queue | TDWMReleaseDelayedRequest | TDWM DELAY REQUEST CHANGE |
| Return the Teradata dynamic workload management software WD summary data fields | TDWMSummary | TDWM SUMMARY |
| Return the collection rate | TDWMSummaryRate | TDWM SUMMARY |
| Return statistics for throttled database objects or throttled workloads | TDWMThrottleStatistics | TDWM STATISTICS |