By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

catalog cache heap question

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.