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

分类:Database 时间:2011-08-01 人气:269
分享到:
blog comments powered by Disqus

相关文章

  • Java to send HTTP requests and extract data of Java code: 2010-08-02

    Java to send HTTP requests and extract data of Java code: import java.io.BufferedReader; import java.io.InputStreamReader; import java.net.URL; public class Main { public static void main(String[] args) { try { URL my_url = new URL("http://www.xasxt.

  • TCP data stream stability - TCP fragmentation, restructuring and out of order 2011-01-25

    TCP data stream stability - TCP fragmentation, restructuring and out of order 1, IP fragmentation situation. IP package has a [slice] and [re] module, an IP datagram in transit can be ip package [slice] module fragment, the receiver B in the destinat

  • Statistics and detailed data output 2011-04-10

    select * from (Select t1 .*, totaltaxfinal, totaltaxfinal2, Ymonth from tb_tax t1 join ( select t.eid, sum (t.taxfinal) as totaltaxfinal, sum (t.taxdue) as totaltaxfinal2, to_char (t.paymentterm, 'yyyy-mm') as Ymonth from tb_tax t group by t.eid, to_

  • Javascript event.keyCode key code value in the table 2010-06-24

    Javascript event.keyCode key code value in the table refer to: http://minghao-1130.spaces.live.com/Blog/cns!CD7E552AFCE2F5AF!1438.entry

  • Java code to generate Excel table 2010-06-24

    Inscription: This is my letter to Yu Yi Cheng's second year, I was transferred to the data sector, now I am endless, and intertwine between data and Excel. 1. We first define these three classes DataItem class, said that the figures within a cell pac

  • Order to help a friend sort some data (a few code + sql) 2010-10-18

    Friends a little more chaos in the data files themselves, then manually adjust a little bit more complicated, people lazy, call me to help do this: I started and I thought it was always seen as telecommunications, where the data, a fairly standard an

  • Reconstruction 13_ practice to improve code maintainability recursive 2010-12-30

    Have such a code is used to resolve internal address information. /** * Gets the province-city . Area array * * @param info * Address information * @return 3 Elements of an array of strings representing province first , The second indicates the city,

  • ThinkPHP mechanism for dealing with massive data points more code table 2011-04-07

    ThinkPHP built-in table algorithm of mega-user data . Data table : house_member_0 house_member_1 house_member_2 house_member_3 In the model class MemberModel extends AdvModel { protected $partition = array('field'=>'username','type'=>'id','num'=>

  • Help a friend sort order some data (a few code + sql) 2010-10-18

    Friends a little more chaotic data files, they manually adjust it a little bit more complicated, people lazy, call me to help do this: I began to think that I've seen with the usual, like telecommunications, where data, a fairly standard and large te

  • Write a small script to the latest statistics the number of lines of code to write 2010-03-27

    class CodeLineStat attr_reader :code_lines def initialize @code_lines = 0 end def stat(path) Dir.foreach(path) do |file| if file != "." && file != ".." then filePath = path + "/" + file if File.directory? filePath the

iOS 开发

Android 开发

Python 开发

JAVA 开发

开发语言

PHP 开发

Ruby 开发

搜索

前端开发

数据库

开发工具

开放平台

Javascript 开发

.NET 开发

云计算

服务器

Copyright (C) codeweblog.com, All Rights Reserved.

CodeWeblog.com 版权所有 黔ICP备15002463号-1

processed in 0.172 (s). 12 q(s)