Hi,
in db2 v8.2 fp9 Enterprice on Linux the default value of CATALOGCACHE_SZ db cfg is MAXAPPLS*4. I have changed this parameter to 800. But now I would like to make it default. How to set CATALOGCACHE_SZ back to value "MAXAPPLS*4"?

Thanks

Pawan

Hi Pawan,

To set CATALOGCACHE_SZ back to value "MAXAPPLS*4"  you have to execute the command below:

db2 update db cfg for <dbname> using CATALOGCACHE_SZ -1

This parameter is allocated out of the database shared memory, and is used to
cache system catalog information. In a partitioned database system, there is
one catalog cache for each database partition.