Teradata Dynamic Workload Management Open APIs (SQL Interfaces) - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

This section describes the Teradata Dynamic Workload Management SQL interfaces that are used to manage the workload and update the stored components (such as, WDs and related data) in the Teradata Dynamic Workload Management. These SQL interfaces consist of UDFs and external stored procedures that you can invoke from any application.

The SQL interfaces to workload management are installed by the DIPTDWM script as part of the database installation (see Requirements for Using the API).

These SQL interfaces provide similar functionality to the Teradata Dynamic Workload Management CLIv2 or Teradata JDBC Driver requests.

You must fully qualify Teradata dynamic workload management software UDFs and Teradata dynamic workload management software external stored procedures with the database name TDWM.

For examples of Teradata dynamic workload management software functions and external stored procedures, see the following topics.