IBM Books

Catalog Cache Inserts


Snapshot Information Level
Database
Application

API Structure(s)
sqlm_dbase
sqlm_appl

Monitor Group
Basic
Basic

Resettable

Yes

 

Event Information Level
Database

API Structure(s)
sqlm_db_event

 

API Element Name
Element Type

cat_cache_inserts
counter

 

Description:  The number of times that the system tried to insert table descriptor information into the catalog cache.

Usage:  Table descriptor information is usually inserted into the cache following a failed lookup to the catalog cache while processing a table, view, or alias reference in an SQL statement. The catalog cache inserts value includes attempts to insert table descriptor information that fail due to catalog cache overflow and heap full conditions.

See Catalog Cache Lookups for more catalog cache information.

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

[ DB2 List of Books | Search the DB2 Books ]