Monitoring data objects using table functions

The data object monitoring perspective provides information about operations performed on data objects, that is tables, indexes, buffer pools, table spaces, and containers.

A different set of monitor elements is available for each object type. Monitor elements for a data object are incremented each time a request involves processing that object. For example, when processing a request that involves reading rows from a particular table, the metric for rows read is incremented for that table.

Use the following table functions to access current details for data objects:
  • MON_GET_BUFFERPOOL
  • MON_GET_TABLESPACE
  • MON_GET_CONTAINER
  • MON_GET_TABLE
  • MON_GET_INDEX

These table functions return data in a relational form.

You cannot access historical data for data objects.

Data object monitor elements are collected by default for new databases. You can use the mon_obj_metrics database configuration parameter to reduce the amount of data collected by the table functions.

The possible values for this configuration parameter are the following:
None
No data object monitor elements are collected
Base
Some data object monitor elements are collected
Extended
All data object monitor elements are collected
To stop collecting data object monitor elements reported by the following table functions, set the mon_obj_metrics configuration parameter to NONE.
  • MON_GET_BUFFERPOOL
  • MON_GET_TABLESPACE
  • MON_GET_CONTAINER