This is a reference book for the Teradata Database application programming interfaces (APIs). It describes the following types of APIs and how they can be used to interface with your own custom applications when other tools (such as, resource usage reports) or client applications do not provide the information you need:
Workload management APIs can be used for creating third-party applications and custom applications requiring the acquisition and use of Teradata Database workload management and performance data.
Note that the workload management PM/APIs described in this manual use monitor software versions 11 and earlier (see “MONITOR VERSION” on page 162 for details). These PM/APIs allow you to create new applications and enhance existing custom applications.
The Automated Statistics Management open APIs can be issued from the Teradata Viewpoint Stats Manager portlet or directly from within customer applications. They can be used to accurately identify unused or out of date statistics, cardinality estimation errors, and override SQL COLLECT STATISTICS statement settings in certain well-defined scenarios.