Package cache, catalog cache, and workspace health indicators

db.catcache_hitratio - Catalog Cache Hit Ratio health indicator

The hit ratio is a percentage indicating how well the catalog cache is helping to avoid actual accesses to the catalog on disk. A high ratio indicates it is successful in avoiding actual disk I/O accesses.

Important: The health monitor, health indicators, and related components have been deprecated in Version 9.7 and might be removed in a future release. Health monitor is not supported in DB2® pureScale® environments. For more information, see Health monitor has been deprecated.

Identifier: db.catcache_hitratio
Health monitor level: Database
Category: Package and Catalog Caches, and Workspaces
Type: Lower-bounded threshold-based
Unit: Percentage

The indicator is calculated using the formula:

(1-(db.cat_cache_inserts/db.cat_cache_lookups))*100

db.pkgcache_hitratio - Package Cache Hit Ratio health indicator

The hit ratio is a percentage indicating how well the package cache is helping to avoid reloading packages and sections for static SQL from the system catalogs as well as helping to avoid recompiling dynamic SQL statements. A high ratio indicates it is successful in avoiding these activities.

Important: The health monitor, health indicators, and related components have been deprecated in Version 9.7 and might be removed in a future release. Health monitor is not supported in DB2 pureScale environments. For more information, see Health monitor has been deprecated.

Identifier: db.pkgcache_hitratio
Health monitor level: Database
Category: Package and Catalog Caches, and Workspaces
Type: Lower-bounded threshold-based
Unit: Percentage

The indicator is calculated using the formula:

(1-(db.pkg_cache_inserts/db.pkg_cache_lookups))*100

Consider using the self-tuning memory feature to have package cache memory resources automatically allocated as required by the current workload. If you have the self-tuning memory feature enabled for the package cache memory area, you should configure this health indicator to disable threshold checking.

db.shrworkspace_hitratio - Shared Workspace Hit Ratio health indicator

The hit ratio is a percentage indicating how well the shared SQL workspace is helping to avoid having to initialize sections for SQL statements that are about to be executed. A high ratio indicates it is successful in avoiding this action.

Important: The health monitor, health indicators, and related components have been deprecated in Version 9.7 and might be removed in a future release. Health monitor is not supported in DB2 pureScale environments. For more information, see Health monitor has been deprecated.

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

Identifier: db.shrworkspace_hitratio
Health monitor level: Database
Category: Package and Catalog Caches, and Workspaces
Type: Lower-bounded threshold-based
Unit: Percentage

The indicator is calculated using the formula:

(1-(db.shr_workspace_section_inserts/db.shr_workspace_section_lookups))*100