DB2 SQL0668N Operation not allowed for reason code "7" on table
来源:互联网 发布:wp10记录仪软件 编辑:程序博客网 时间:2024/06/07 11:03
db2 => select count(*) from db2admin.test_tab
1
-----------
SQL0668N Operation not allowed for reason code "7" on table
"DB2ADMIN.test_tab". SQLSTATE=57016
db2 => force application all
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
db2 => terminate
DB20000I The TERMINATE command completed successfully.
[db2inst1@db10g ~]$ db2stop
06/14/2016 20:32:43 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
[db2inst1@db10g ~]$ db2start
06/14/2016 20:32:47 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
db2 => select count(*) from db2admin.test_tab
1
-----------
SQL0668N Operation not allowed for reason code "7" on table
"DB2ADMIN.test_tab". SQLSTATE=57016
db2 => REORG TABLE db2admin.test_tab ALLOW NO ACCESS KEEPDICTIONARY
DB20000I The REORG command completed successfully.
db2 => select count(*) from db2admin.test_tab
1
-----------
679
1 record(s) selected.
阅读全文
0 0
- SQL0668N Operation not allowed for reason code "7" on table
- DB2 SQL0668N Operation not allowed for reason code "7" on table
- DB2 alter table 的字段后,不能添加新数据,报错SQL0668N Operation not allowed for reason code "7" on table
- Operation not allowed for reason code SQL0668N
- Operation not allowed for reason code SQL0668N
- Operation not allowed for reason code SQL0668N
- DB2数据库 Operation not allowed for reason code "7" on table 原因码 "7"的解决方法
- DB2数据库表操作错误SQL0668N Operation not allowed for reason code "1" on table "XXXX". SQLSTATE=57016的解决方法
- Operation not allowed for reason code "7" on table 原因码 "7"的解决
- Operation not allowed for reason code "7" on table 原因码 "7"的解决
- DB2中SQL0668N Reason code "1"以及SQL3603N报错的处理
- db2 SQL0668N 原因码7问题解决
- TD中查询出错: Operation not allowed: <Schema>.<Table> table header has invalid partitioning.
- ORA-30657: operation not supported on external organized table
- DB2 mainframe table operation DML
- 关于蓝牙通讯报 The operation is not allowed on non-connected sockets. 错误
- 错误:Operation not allowed after ResultSet closed
- Operation not allowed after ResultSet closed
- 《jenkins部署》
- LESS预处理器
- 最大似然估计和最小二乘法
- 02React的JSX 与Style
- RASAC 入门
- DB2 SQL0668N Operation not allowed for reason code "7" on table
- bzoj 1827: [Usaco2010 Mar]gather 奶牛大集会
- oracle学习笔记
- C语言经典知识示例之01怎样确定float类型变量的有效数字个数
- leetcode 718( Maximum Length of Repeated Subarray)
- 【POJ
- mysql JDBC URL格式各个参数详解
- Target Sum
- 周中训练笔记15