DB2 SQL0668N Operation not allowed for reason code "7" on table code instance, db2sql0668n
DB2 SQL0668N Operation not allowed for reason code "7" on table code instance
db2 => select count(*) from db2admin.test_tab1 -----------SQL0668N Operation not allowed for reason code "7" on table "DB2ADMIN.test_tab". SQLSTATE=57016db2 => force application allDB20000I The FORCE APPLICATION command completed successfully.DB21024I This command is asynchronous and may not be effective immediately.db2 => terminateDB20000I The TERMINATE command completed successfully.[db2inst1@db10g ~]$ db2stop06/14/2016 20:32:43 0 0 SQL1064N DB2STOP processing was successful.SQL1064N DB2STOP processing was successful.[db2inst1@db10g ~]$ db2start06/14/2016 20:32:47 0 0 SQL1063N DB2START processing was successful.SQL1063N DB2START processing was successful.db2 => select count(*) from db2admin.test_tab1 -----------SQL0668N Operation not allowed for reason code "7" on table "DB2ADMIN.test_tab". SQLSTATE=57016db2 => REORG TABLE db2admin.test_tab ALLOW NO ACCESS KEEPDICTIONARYDB20000I The REORG command completed successfully.db2 => select count(*) from db2admin.test_tab1 ----------- 679 1 record(s) selected.