15.10 - Examples Using Open APIs - Teradata Database

Teradata Database Application Programming Reference

Teradata Database
Programming Reference

The following table describes the different uses of the System PMPC open APIs.


You can ...

To ...

execute the MonitorSession and AbortSessions functions

create a query that aborts queries submitted by a set of users that have been running longer than 10 minutes and have been skewed by more than 30% for 20 minutes.

execute the MonitorSession and SetSessionAccount functions

change the account string.

execute the MonitorSession or MonitorSQLText functions

display the SQL of all active sessions that have run over 20 minutes.

select the blocked fields of the MonitorSession function

display the block information of all blocked sessions.