PM/APIs and open APIs, also called SQL interfaces, are divided into the following
Teradata Dynamic Workload Management
Embedded services system is another category that applies only to some of the SQL
interfaces (for example, the GetPSFVersion and TD_get_COD_limits functions).
The following diagram shows how:
The System PMPC, Teradata Dynamic Workload Management, and Query Band PM/API requests
(such as Call-Level Interface Version 2 [CLIv2] and the Teradata JDBC Driver) interface
to the PMPC subsystem through the MONITOR partition.
Note: These PM/APIs are supported by both Call-Level Interface Version 2 (CLIv2) and the
Teradata JDBC Driver. For more information on how the Teradata JDBC Driver requests
are executed, see Teradata JDBC Driver Reference.
The System PMPC and Teradata Dynamic Workload Management SQL interfaces (such as,
user-defined functions and external stored procedures) connect to the PMPC subsystem
through the SQL partition, except TDWMApply, TDWMRuleControl, and TDWMSetLimits. These
APIs connect to the Teradata Database system through the SQL partition and are not
shown in the diagram below.
The embedded services system and most Query Band SQL interfaces connect to the SQL
partition, except MonitorQueryband. This SQL interface is the only Query Band API
that connects to the PMPC subsystem through the SQL partition and is not shown in
the diagram below.
For more information on these APIs, see:
Chapter 3: “Workload Management API Features and Examples”
Chapter 4: “System PMPC APIs”
Chapter 5: “Teradata Dynamic Workload Management APIs”
Chapter 6: “Query Band APIs”
Chapter 7: “Embedded Services System APIs”