DB2 SQL0668N Operation not allowed for reason code "7" on table代码实例,db2sql0668n
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.
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。