Brother-Eagle® DB2 Performance
Advice: Catlg OvFlo

Catalog Cache Overflows can occur when the demand for concurrent Catalog Cache Memory exceeds the amount of memory available. This is most like to occur when many statements are being simultaneously prepared in high volume OLTP database environments.

Brother-Eagle will indicate a warning if two or more Catalog Cache Overflows occur. An alert status will be indicated if four or more Catalog Cache Overflows occur.

Since Catalog Cache memory is drawn from DBHEAP memory, if Catalog Cache Overflows occur, then you should increase both the CATALOGCACHE_SZ and DBHEAP by 10% until overflows stop occuring.

View full list of DB2 LUW advice topics