Any operation on the table are not allowed, suggesting SQLSTATE = 57016 SQLCODE =- 668, reason code "7" error: SQL0668N Operation not allowed for reason code "7" on table XXX.
SQLSTATE 57016: table is not active because it can not be accessed.
Solution is: Execute the command: reorg table XXX; can.
Reference to read:
Operation not allowed for reason code reason-code on table table-name.
Explanation: access to table table-name is restricted. The cause is based on the following reason codes reason-code: 7
The table is in the reorg pending state. This can occur after an ALTER TABLE statement containing a REORG-recommended operation.7
Reorganize the table using the REORG TABLE command (note that INPLACE REORG TABLE is not allowed for a table that is in the reorg pending state).
reorg table through the reconstruction of the line to eliminate the "fragmentation" of data and compression information, the table reorganization.
runstats on table. collection of table statistics.
reorgchk on table all to determine the need to restructure the table for all tables automatically runstats useful.
>>> Reorg runstats are single table and optimize initialization commands:
runstats on table administrator.test;
reorg table administrator.test;
Data reference: http://www.knowsky.com/400313.html
Related Posts of DB2 sqlstate 57016 reason code "7" Detailed error
User.create ([(: first_name => 'Jamie'), (: first_name => 'Jeremy')]) do | u | u.is_admin = false end people = (1 => ( "first_name" => "David"), 2 => ( "first_name" => "Jeremy" ...
Transfer from Zhu Shaomin ID : KerryZhu http://blog.csdn.net/KerryZhu/archive/2009/02/28/3945871.aspx First answer here Hundred software developers interview question Test part of the future have time to answer software engineering, software project manag
Rails 1.x days recalled by the Rails core members of Jamis Buck And Michael Koziarski Created The Rails Way Are the most influential one Rails site, the site is aimed at the creation of the code submitted to the site to comment and reconstruction to ...
Financial crisis has come, the project got worse, employees are brothers, should not because there is no project, on vacation or dismissal. However, small businesses, how many did not make money, can only help each other to tide over the difficulties. As
<Private http://www.javaeye.com/topic/320633> Recently, ext finally make use of a small web project. Ext used for the first time to do the project, after all, lack of experience, just write down a number of development ideas and required attention.
Rails applications easier to encounter two types of performance problems: Rails implementation of a class are very slow, CPU consumption too high; The other is the process of memory leaks Rails. To resolve these two types of questions are necessary before
Error message: org.hibernate.LazyInitalizationException ..., no session or session was closed Analysis: When the statistics when the number of sub-classification, entity objects are already in session beyond the free state, Hibernate's transactio ...
I was a time not long into the company of people, but also a person to be graduated, but immediately entered the project team, involved in the development. The project is to make a China Telecom Operation System, is a big system. My so-called develop ...