473,320 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

reorg and reorgchk

does anyone have an idea as to why the reorgchk utility says that a
particular table needs to be reorged even after running the reorg
command on that particular table. answer is appreciated.

Feb 12 '06 #1
2 2341
If the table has more than one index and one of them is a clustering index
then after an offline reorg the table will be fine and sequenced, the
cluster ratio of the clustering index will be a 100% but the other index(es)
may show a cluster ratio less than 80%.
At that point the reorgchk command does not know which index is the
clustering one (it may be one specified in a previous reorg command). It
will then show that the table needs to be reorg'ed because those other
index(es) may be out of cluster.

Now, if the reorg is INPLACE (meaning online), then the reorg wil do one and
only one of two things, never both:
1) Reclaim space if there is no clustering index defined or index specified
in the reorg command.
Then a reorgchk afterwards may show that the table need reorg
because some index(es) is out of cluster.
2) Resequence the table according to: An index with a cluster clause or an
index specified.
A reorgchk afterwards could show need because space could be
reclaimed.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"EpsilonAurigae" <ab**************@gmail.com> a écrit dans le message de
news: 11**********************@g14g2000cwa.googlegroups. com...
does anyone have an idea as to why the reorgchk utility says that a
particular table needs to be reorged even after running the reorg
command on that particular table. answer is appreciated.


Feb 13 '06 #2
Ian
EpsilonAurigae wrote:
does anyone have an idea as to why the reorgchk utility says that a
particular table needs to be reorged even after running the reorg
command on that particular table. answer is appreciated.


It depends on why REORGCHK says that the table needs to be reorganized.
Post the output.

Also, did you update statistics again after REORG?

Feb 13 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: TomHorner | last post by:
I have several quick questions about reorg's, and a request (favor). 1. The documentation says that reorg "Reorganizes an index or a table" I cannot see how one would reorg ONE particular index...
1
by: hikums | last post by:
1. I did a reorgchk, and found that F2 on table and F4 on index indicates a reorg is necessary. 2. Did a reorg. 3. Again I do a reorgchk, the report is the same as in Step 1 4. I do a...
16
by: andy.standley | last post by:
Hi, we are running DB2 V8.2 (8.1.0.80) on redhat linux and I am trying to set the reorg to be online. I use the control center on the box - db2cc and then configure automatic maintenance wizard -...
2
by: Molly | last post by:
Does anyone know of any good tools for fast, on-line reorgs of a very large DB2 UDB table? We need to reorg a couple of our large (+1 billion rows) tables. We migrated from V7.2 to V8.1, but we...
4
by: cmitchell | last post by:
Hi, I am looking for some suggestions as to what i can do to improve the following situation. If there is more detail you require please ask.. There are users inserting/altering data into a...
1
by: Harold Pritchett | last post by:
I have a v8.2 db2 server (FixPak 7a) running on RedHat Enterprise linux v3 (2.4.21-37.ELsmp kernel) Currently there is one database which appears to badly need reorganization. I'm new to this...
0
by: datapro01 | last post by:
Running DB2 8.2.6 on AIX 5.3 I recently took on an assignment supporting a DB2 database which supports a Siebel application. Siebel version is 7.5.3 I have a reorg script that carefully...
2
by: Okonita | last post by:
Hi all, How can I implement using REORGCHK to tell REORG what DB2 UDB v8 tables, etc to perform REORG on? Any example script will be highly appreciated. Okonita
7
by: Okonita via DBMonster.com | last post by:
Hi all, I am very surprised to see that after doing a Reorgchk followed by reorg of selected tables and concluding with a runstats of the reorged tables, all of the tables continue to be...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.