1 问题现象
db2diag.log日志抛出错误
https://www.cndba.cn/hbhe0316/article/4894
https://www.cndba.cn/hbhe0316/article/4894
https://www.cndba.cn/hbhe0316/article/4894
https://www.cndba.cn/hbhe0316/article/4894
https://www.cndba.cn/hbhe0316/article/4894
https://www.cndba.cn/hbhe0316/article/4894
Could not fix page for ObjID=285,tbspace=7,objType=128,ParentObjID=285 parentTbspaceID=8
2 问题诊断
该问题为bufferpool不足导致。https://www.cndba.cn/hbhe0316/article/4894
https://www.cndba.cn/hbhe0316/article/4894
https://www.cndba.cn/hbhe0316/article/4894
https://www.cndba.cn/hbhe0316/article/4894
3 恢复步骤
su - <instance>
db2 connect to <dbname>
db2 -db <dbname> -bufferpool
db2 alter bufferpool <bufferpool_name> immediate size <size_value>
版权声明:本文为博主原创文章,未经博主允许不得转载。
DB2