15.10 - Accessing PM/API-Related Data in the Data Dictionary - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

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
  • Note: 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, are 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.

    Example  

    To determine who is using the monitor, enter the following:

    SELECT UserName, IFPNo FROM DBC.SessionInfoV
       WHERE Partition = ’MONITOR’ ;

    Example  

    To determine what users have the privilege to force other users off the system, enter the following:

    SELECT DISTINCT UserName FROM DBC.AllRightsV
       WHERE AccessRight = ’AS’ ; 

    The ‘AS’ indicates the ABORT SESSION privilege.

    Example  

    To find out what users have been forced off the system (using PM/API ABORT SESSION) in the past two days, enter the following:

    SELECT DISTINCT UserName FROM DBC.LogOnOffV
       WHERE Event = ’Forced Off’
       AND LogDate > DATE - 3 ;