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:
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.
The following Data Dictionary views, which are built on those tables, are also carry
The following example queries return information about PM/API‑related activities.
To determine who is using the monitor, enter the following:
SELECT UserName, IFPNo FROM DBC.SessionInfoV
WHERE Partition = ’MONITOR’ ;
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.
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 ;