467,199 Members | 1,042 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

catalog cache heap question

Hi,
could anyone explain the relationship between the "Catalog cache heap"
in the db2mtrk output and the database config parameter
catalogcache_sz.

Thanks,
Hype.
Nov 12 '05 #1
  • viewed: 1477
Share:
1 Reply
I think they represent one and the same thing. :-) Keep in mind that the
catalog cache can grow into other areas of dbms shared memory...so if
the value being reported is higher than your mtrk stuff, it's because
your cache needed to grown beyond the max. Have a look at the db
snapshot values for the high water mark and number of cache overflows to
see if you might need to bump up the size of the cache.

hype wrote:
Hi,
could anyone explain the relationship between the "Catalog cache heap"
in the db2mtrk output and the database config parameter
catalogcache_sz.

Thanks,
Hype.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Kevin Grigorenko | last post: by
2 posts views Thread by Simon Strandgaard | last post: by
3 posts views Thread by maricel | last post: by
3 posts views Thread by Amy DBA | last post: by
reply views Thread by shterke | last post: by
3 posts views Thread by Raj | last post: by
2 posts views Thread by =?Utf-8?B?Y2F0?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.