Enterprise Edition
Customer Service

Brother-Eagle Community

  • Visit/Join Now!
  • Get tips from other users!
  • Share your own tips, advice, and metric formulas!

DBI Products

Brother-Eagle® DB2 Performance
Advice: Catlg Hit%

The CATALOGCACHE_SZ database configuration parameter specifies the amount of memory DB2 has available for storing information about defined objects (tables, indexes, etc). This memory is used to speed up prepare times for dynamic SQL and binds of static SQL.

When the Catalog Cache Hit Ratio is high, this is good because it means DB2 is avoiding I/O to the Catalog tables when preparing statements.

Brother-Eagle will indicate a warning if the Catalog Cache Hit Ratio is 95% or less and an alert status if 90% or less.

If the Catalog Cache Hit Ratio is less than 91%, consider increasing the CATALOGCACHE_SZ by 5% increments until a hit ratio of 95% or higher is achieved.

View full list of DB2 LUW advice topics