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

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.