DB2遇到这样一个问题。 ‘’Operation not allowed for reason code "7" on table "DB2ADMIN.XXX". SQLSTATE=5701‘’

最新推荐文章于 2024-08-07 15:34:14 发布

dachaoa

最新推荐文章于 2024-08-07 15:34:14 发布

阅读量2.3k

点赞数

分类专栏：原创文章标签： DB2 code7

本文链接：https://blog.csdn.net/dachaoa/article/details/83279116

版权

工作中数据库：DB2遇到这样一个问题。 ‘’Operation not allowed for reason code “7” on table “DB2ADMIN.XXX”. SQLSTATE=5701‘’
经过搜索找到解决办法：
解决办法：执行reorg table CALL SYSPROC.ADMIN_CMD(‘reorg table issue.T_DISPUTE’) 就好了，不明白
对表进行任何操作都不被允许，提示SQLSTATE=57016 SQLCODE=-668 ，原因码 "7"的错误：SQL0668N Operation not allowed for reason code “7” on table XXX. 解决方法为：执行命令：reorg table XXX；即可。
参考原文为：
Operation not allowed for reason code reason-code on table table-name.
Explanation: Access to table table-name is restricted. The cause is based on the following reason codes reason-code: 7
The table is in the reorg pending state. This can occur after an ALTER TABLE statement containing a REORG-recommended operation.7
Reorganize the table using the REORG TABLE command (note that INPLACE REORG TABLE is not allowed for a table that is in the r