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,我们会在尽快处理。