DB2 CATALOGCACHE_SZ不足

1 问题现象
db2diag.log日志中抛出Warning，显示catalogcache_sz值不足。https://www.cndba.cn/hbhe0316/article/4889https://www.cndba.cn/hbhe0316/article/4889https://www.cndba.cn/hbhe0316/article/4889

2 问题诊断
查看db2diag.log日志https://www.cndba.cn/hbhe0316/article/4889https://www.cndba.cn/hbhe0316/article/4889

https://www.cndba.cn/hbhe0316/article/4889

https://www.cndba.cn/hbhe0316/article/4889

ADM4000W A catalog cache overflow condition has occurred.There is no error but this indicates that the catalog cache persists,you may want to adjust the CATALOGCACHE_SZ DB configuration parameter

3 恢复步骤
在规范值10240基础上调大到20480https://www.cndba.cn/hbhe0316/article/4889

https://www.cndba.cn/hbhe0316/article/4889

https://www.cndba.cn/hbhe0316/article/4889

db2 update db cfg for <dbname> using CATALOGCACHE_SZ 20480

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2