DB2相关报错问题 DB21019E SQLSTATE 57016
SQLSTATE 57016)
DB21019E
An error occurred while accessing the directory “/root”.
#根据自己的用户路径修改权限
chmod -R 775 /db2/db2home/db2inst1
SQLSTATE 57016
The table cannot be accessed, because it is inactive.
输入下面的命令查看,发现为reorg pending状态
db2 => load query table pers
Tablestate:
Reorg Pending
输入下面的命令使状态恢复正常
db2 => reorg table pers
再输入下面的命令查看,发现状态转为正常,即可正常执行sql语句
db2 => load query table pers
Tablestate:
Normal
有关reorg pending的详细介绍可以查看这篇博客的内容https://www.talkwithtrend.com/Article/184323