IBM Books

Package Cache Inserts


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

pkg_cache_inserts
counter

 

Description:  The total number of times that a requested section was not available for use and had to be loaded into the package cache.

Usage:  In conjunction with "Package Cache Lookups", you can calculate the package cache hit ratio using the following formula:

    1 - (Package Cache Inserts / Package Cache Lookups)

See Package Cache Lookups for information on using this element.

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

[ DB2 List of Books | Search the DB2 Books ]