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.