16.20 - Accessing PM/API-Related Data in the Data Dictionary - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Several Data Dictionary tables log Performance Monitor/Application Programming Interface (PM/API)-related values for some columns. You can use the PM/API information to track the use of MONITOR partition functions.

The following DBC tables contain PM/API information:

  • DBC.AccessRights
  • DBC.SessionTbl
  • DBC.SW_Event_Log
    Execution of the PM/API SET RESOURCE, SET SESSION, and ABORT SESSION requests are considered major system events and are logged to the DBC.SW_Event_Log table.
  • DBC.Dbase
  • DBC.TVM

The following Data Dictionary views, which are built on those tables, also carry PM/API-related data:

  • AllRightsV[X]
  • AllSpaceV[X]
  • DatabasesV[X]
  • DiskSpaceV[X]
  • LogOnOffV
  • Software_Event_LogV
  • SessionInfoV[X]
  • UserGrantedRightsV
  • UserRightsV

The following example queries return information about PM/API-related activities.