Hi,
in db2 v8.2 fp11 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"?
Regards,
Grofaty

Try setting it to NULL (uppercase)

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



db2 update db cfg for dbatodba 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.