DB2 sqlstate 57016 reason code "7" Detailed error

DB2 sqlstate 57016 reason code "7" Detailed error

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.

First check:

db2? 57016

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).

Of which:

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
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of DB2 sqlstate 57016 reason code "7" Detailed error

  • JavaScript access to HTML DOM node element method summary

    At Web application development in particular Web2.0 often to access a page element, then update the elements of style, content, etc.. How to obtain the elements to be updated, is the first problem to be solved. It is gratifying that the use of JavaScript

  • rails 2.2 base.rb

    User.create ([(: first_name => 'Jamie'), (: first_name => 'Jeremy')]) do | u | u.is_admin = false end people = (1 => ( "first_name" => "David"), 2 => ( "first_name" => "Jeremy" ...

  • Hundred developers interview question - test part of the answer

    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

  • The Rails Way back

    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 ...

  • Student candidates for software recommendations

    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

  • Ext project summary

    <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 to monitor the process of memory leaks skills

    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

  • Ajax Portal

    The first test procedure: <html> <title>Full use XMLHttpRequest to load the document example </title> <head> <script type='text/javascript'> var req=null; var console=null; var READY_STATE_UNINITIALIZED=0; var READY_STATE_LOA

  • org.hibernate.LazyInitalizationException

    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 ...

  • The company first entered the company I would like to Optimize SQL project

    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 ...

blog comments powered by Disqus
Recent
Recent Entries
Tag Cloud
Random Entries