Skip to Main Content
IBM Db2 11.1 Certification Guide
book

IBM Db2 11.1 Certification Guide

by Robert (Kent) Collins, Mohankumar Saraswatipura
June 2018
Intermediate to advanced content levelIntermediate to advanced
478 pages
10h 52m
English
Packt Publishing
Content preview from IBM Db2 11.1 Certification Guide

Monitoring data objects

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Red Hat RHCSA 8 Cert Guide: EX200, 2nd Edition

Red Hat RHCSA 8 Cert Guide: EX200, 2nd Edition

Sander van Vugt

Publisher Resources

ISBN: 9781788626910Other