IBM Books

Number of Table Spaces


Snapshot Information Level
Table Space

API Structure(s)
sqlm_tablespace_header

Monitor Group
Buffer Pool

Resettable

No

 

API Element Name
Element Type

num_tablespaces
gauge

 

Description:  The number of table spaces for which snapshot information is available.

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

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

[ DB2 List of Books | Search the DB2 Books ]