Data object monitoring focuses on providing information about operations performed on the data objects such as tables, indexes, buffer pools, table spaces, and containers. The following table shows the table functions available in Db2 v11.1 for accessing data object information:
|
Table Function |
Information Returned |
|
MON_GET_BUFFERPOOL |
Returns monitor metrics for one or more buffer pools |
|
MON_GET_TABLESPACE |
Returns monitor metrics for one or more table spaces |
|
MON_GET_CONTAINERS |
Returns monitor metrics for one or more table space containers |
|
MON_GET_TABLE |
Returns monitor metrics for one or more tables |
|
MON_GET_INDEXES |
Returns monitor metrics for one or more indexes |
If you want to ...
