15.10 - Examples Using Open APIs - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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.