A new set of administrative views are available in the SYSIBMADM schema to extract database monitoring information in a relational table format. Unlike monitoring table functions, administrative views do not require input parameters.
The SYSIBMADM schema holds the built-in monitoring administrative views and it requires one of the following authorizations to run these views:
- SELECT privilege on a specific view
- CONTROL privilege on a specific view
- DATAACCESS authority
- DBADM authority
- SQLADM authority
The following table lists the monitoring administrative views constructed on the newer lightweight, high-speed monitoring solution:
|
Administrative View Name |
Information Returned |
|
MON_BP_UTILIZATION |
Returns key monitoring metrics for buffer pools, including hit ratio and average read and write times across all the database partitions... |