This section describes how to access PMPC data through SQL interfaces consisting of UDFs. The PMPC UDFs, like the PMPC PM/API requests, are used to monitor system and session-level performance and set collection and logging rates. However, the PMPC UDFs can be invoked from any application.
The PMPC UDFs provide similar functionality to the PMPC PM/API requests.
You need not fully qualify PMPC UDFs by the database name, SYSLIB, because the DBS automatically searches that database for these UDFs.
- AbortListSessions
- AbortSessions
- IdentifyDatabase
- IdentifySession
- IdentifyTable
- IdentifyUser
- MonitorAMPLoad
- MonitorAWTResource
- MonitorMySessions
- MonitorPhysicalConfig
- MonitorPhysicalResource
- MonitorPhysicalSummary
- MonitorSession
- MonitorSessionRate
- MonitorSQLCurrentStep
- MonitorSQLSteps
- MonitorSQLText
- MonitorSystemPhysicalConfig
- MonitorVirtualConfig
- MonitorVirtualResource
- MonitorVirtualSummary
- MonitorWD
- MonitorWDRate
- SetResourceRate
- SetSessionAccount
- SetSessionRate