Applications: Cache (DB2 UDB for UNIX and Windows) (SAP Library

Applications: Cache (DB2 UDB for UNIX and Windows)

To display information on cache for your selected application(s), call the DBA Cockpit.

...

1. In the navigation frame, choose Performance ®Applications.

The Application Snapshot screen appears.

2. To display more detailed information, select one or more applications and choose This graphic is explained in the accompanying text Details.

A detail Application Snapshot screen appears.

3. Choose Cache.

If you have selected more than one application, you can use the page buttons on the screen to navigate between them.

Field	Description
*Catalog Cache*
Quality	Indicates percentage at which the data is read from the catalog cache, rather than directly from the hard disk. This is calculated using the following formula: (catalog cache lookups - catalog cache insert) / catalog cache lookups * 100
Lookups	Number of times that the catalog cache was referenced to obtain table descriptor information
Inserts	Number of times that the system tried to insert table descriptor information into the catalog cache
Overflows	Number of times that an insert into the catalog cache failed due to the catalog cache being full
Heap Full	Number of times that an insert into the catalog cache failed due to the database heap being full
*Package Cache*
Quality	Indicates percentage at which the data is read from the package cache, rather than directly from the hard disk. This is calculated using the following formula: (package cache lookups - package cache inserts) / package cache lookups * 100
Lookups	Number of times an application looked for a section in the package cache
Inserts	Total number of times that a request section was not available for use and had to be loaded into the package cache