加载中…
  
博文
标签:

数据库

db2

杂谈

分类: 数据库—DB2

DB2中SQLSTATE=57016 SQLCODE=-668,原因码 '7'的解决

对表进行任何操作都不被允许,提示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 reorg pending state).
其中:
   reorg   table   <tablename>  

  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有