If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Question on reorgs/reorgchk

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-09-06, 07:47
SnowCrash7 SnowCrash7 is offline
Registered User
 
Join Date: Mar 2004
Posts: 42
Question on reorgs/reorgchk

Running DB2 8.2 on AIX 5.2

I have a question on reorgs and reorgchk results. My reorg script is
using the db2reorgchk to determine if a table or an index needs to be reorged. If a table needs to be reorged I reorg it and then do a runstats.

Then I do another reorgchk to see if the indexes need to be reorged after the table reorg.

If so I do a reorg indexes all for the table followed by a runstats.

If this process is faulty please let me know.

The question I have is that even after a reorg of both the table and/
or the indexes, a non-clustered index will sometimes still show a need
to be reorged in F6, the factor that deals with the number of nlevels
of an index.

Why would it still show that after a reorg indexes all allow no access
for that table? Aren't the indexes being rebuilt?

Thanks in advance.

Gerry
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On