IBM Books

Catalog Cache Heap Full


Snapshot Information Level
Database
Application

API Structure(s)
sqlm_dbase
sqlm_appl

Monitor Group
Basic
Basic

Resettable

Yes

 
Event Information Level
Database
Connection

API Structure(s)
sqlm_db_event
sqlm_conn_event

 
API Element Name
Element Type

cat_cache_heap_full
counter

 

Description:  The number of times that an insert into the catalog cache failed due to a heap-full condition in the database heap.

Usage:  The catalog cache draws its storage dynamically from the database heap and even if the cache storage has not reached its limit, inserts into the catalog cache may fail due to a lack of space in the database heap.

If the catalog cache heap full count is not zero, then this insert failure condition can be corrected by increasing the database heap size or reducing the catalog cache size.

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

[ DB2 List of Books | Search the DB2 Books ]