REORGCHK

[kozlow]

When we use REORGCHK to decide which tables and indexes to reorg, then run the reorgs, runstats and rerun the REORGCHK, most times the values do not change....

I have looked at the DB2 manuals and they give a brief overview or the formulas.

Is there a redbook artical that goes in depth of what should be done to resolve each of the F1, F2, F3, F4, ETC...

Thanks...

Tired of spending 12 hours every weekend reorging the tables and indexes with little benifit.

 

[LKBrwnDBA]

Easy, migrate to Oracle.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[MarcLodge]

Kozlow,
Have you looked at the book SC09-4828 UDB Command Ref? It can be found here:

http://publibfp.boulder.ibm.com/epubs/pdf/c0948280.pdf

There's quite a lot of info in there on REORGCHK. It starts on the numbered page 576 although for some reason in my adobe that appeared to be 586.

Don't know if this is what you are looking for or if you're after something more.

Let me know.

Marc

 

[blom0344]

Easy, migrate to Oracle.

Which would solve what problem?

Ties Blom

 

[kozlow]

It would solve ours.... We do not have a DB2 DBA... We do have an Oracle DBA.

I did read the REORGCHK from the manual, but it still does not help me resolve why the reorgchk gives the same values before and after a reorg of a table and recreation of a index. RUNSTATS was run in each case.

I was told to use F4 if a cluster or primary index, but not if a regular. I am not sure why.

No use reorging and recreating if we see no benifit. It also increases our downtime as it does not allow for online reorgs....

Thanks again, and if you have any suggestions.....

 

[blom0344]

my suggestion:

http://www.dbforums.com/forumdisplay.php?f=8

which has about 220 entries on reorgchk alone. Perhaps you could pm sathyaram about your issue. He may even drop in on tek-tips once in a while

Ties Blom