Open APIs (SQL Interfaces) - Advanced SQL Engine - Teradata Database

Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
hvk1593628831140.ditamap
dita:ditavalPath
hvk1593628831140.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantageā„¢

This section describes how to access PMPC data through SQL interfaces consisting of UDFs. The PMPC UDFs, like the PMPC PM/API requests, are used to monitor system and session-level performance and set collection and logging rates. However, the PMPC UDFs can be invoked from any application.

The PMPC UDFs provide similar functionality to the PMPC PM/API requests.

When issuing PMPC UDFs, you do not need to fully qualify them by the database name, SYSLIB. They are automatically searched by the DBS in the SYSLIB database.