ADM4000W and catalogcache_sz

17 January,2012 by Jack Vamvas

The following message appeared in the db2diag.log

ADM4000W  A catalog cache overflow condition has occurred.  There is

          no error but this indicates that the catalog cache has exceeded the

          configured maximum size.  If this condition persists, you may want to

          adjust the CATALOGCACHE_SZ DB configuration parameter

 Notes on CATALOGCACHE_SZ

 1)    CATALOGCACHE_SZ is the Catalog cache size configuration parameter

2)   Specifies in pages the max space usable from database heap

3)  CATALOGCACHE_SZ allocation occurs from database shared memory

4)   If increasing CATALOGCACHE_SZ allocation consider the consequences  versus allocating the memory for other resources such as bufferpool

5)  Large amounts of dynamic sql or XQuery can potentially require extra cache space.

6)      Monitor : cat_cache_lookups , cat_cache_inserts , cat_cache_overflows , cat_cache_size_top    for hints to adjust catalogcache_sz

 

 

See Also

DB2 event monitor and snapshot monitor

 DB2 Instance Memory and dbptnmem

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on ADM4000W and catalogcache_sz

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright