16.20 - Open APIs (SQL Interfaces) - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

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.