15.10 - Preface - Teradata Database

Teradata Database Application Programming Reference

Teradata Database
Programming Reference

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 API”
  • 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.

  • “Automated Statistics Management API”
  • 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.

    Related Documentation

  • If your custom application uses an earlier monitor version, depending on the version used, see previous releases of Workload Management API: PM/API or Open API, PM/API Reference, or Application Programming Reference: Workload Management.
  • For information on Teradata Viewpoint Stats Manager portlet, see Teradata Viewpoint User Guide.
  • For more information about the workload management (WM) capacity on demand (COD) feature, see Carrie Ballinger, Workload Management Capacity on Demand: Teradata Database 14.10 and Linux SLES 11, Teradata Database Orange Book 541-0010245.