DB2 Version 9.7 for Linux, UNIX, and Windows

pkg_cache_size_top - Package cache high watermark monitor element

The largest size reached by the package cache.

Note: The pkg_cache_size_top monitor element is deprecated starting with DB2® Version 9.5. Using this monitor element will not generate an error. However, it does not return a valid value. This monitor element is no longer recommended and might be removed in a future release.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-

Usage

If the package cache overflowed, then this element contains the largest size reached by the package cache during the overflow.

Check the pkg_cache_num_overflows monitor element to determine if such a condition occurred.

You can determine the minimum size of the package cache required by your workload by:

   maximum package cache size / 4096

Rounding the result up to a whole number, indicates the minimum number of 4K pages required by the package cache to avoid overflow.