IBM Books

Number Of Tables with Monitor Output


Snapshot Information Level
Table

API Structure(s)
sqlm_table_header

Monitor Group
Table

Resettable

No 

 

API Element Name
Element Type

num_tables
gauge

 

Description:  The number of tables that have been accessed since "First Database Connect Timestamp"..

Usage:  This number indicates the number of tables for which the database system monitor is returning information in the buffer area. Its primary use is to help determine the number of sqlm_table records that are in the database system monitor buffer area.

The access could have been a read from or a write to the table.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]