欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

DB2 SQL0668N Operation not allowed for reason code "7" on table代码实例

程序员文章站 2022-06-17 19:13:28
DB2 SQL0668N Operation not allowed for reason code "7" on table代码实例 db2 =>...

DB2 SQL0668N Operation not allowed for reason code "7" on table代码实例

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.