DB2相关报错问题

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