DB2 实例文件权限错误

1.问题现象
CDC连接DB2抛错或者应用用户通过命令连接库抛错：

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

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

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

db2 connect to <dbname> user <username> using <passsword>
SQL1639N The database server was unable to perform authentication because security-related database manager files on the server do not have the requirement permissions,SQLSTATE=08001

2.问题诊断
Db2diag.log日志抛出错误

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

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

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

Password validation for user <username> failed with rc = -2146498587

3.恢复步骤https://www.cndba.cn/hbhe0316/article/4874

su - <instancename>
db2 force application all
db2 deactivate db <dbname>
db2stop force
su - root
cd /opt/ibm/db2/Vxx.x/instance
./db2iupdt -k <instancename>

4.更新实例完成后

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

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

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

su - <instancename>
db2start
db2 activate db <dbname>
如果是HADR环境，在每个HADR节点执行命令查看HADR的状态
db2pd -db <dbname> -hadr

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

DB2