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. Using this health indicator will not generate an error. However, it does not return a valid value 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