468,121 Members | 1,353 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,121 developers. It's quick & easy.

Question on Reorgs

Running DB2 8.2 on AIX 5.2

I have a question on reorgs and reorgchk results. My reorg script is
using the db2reorgchk (which I understand has certain limitations) to
determine if a table or an index needs to be reorged. The presence of
an asterisk in the output for the table triggers a reorg of the table
using the clustered index if it has one...allow no access.

Then runstats

Then if the reorg was done, I do another reorgchk to see if the indexes
still need to be reorged.

If there is an asterisk in the indexes output, any of them, then I do a
reorg indexes all for that table
Then another 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

Jun 8 '06 #1
2 1644
Have you considered the size of the table. When card increases,
eventually more than three levels will be needed for the index. The only
solutions to decrease the number of levels in the index is to increase
the size of the index page or decrease the number of rows in he table.
Increasing the index page size may run into the limit on how many rows
can be placed in the page.

Phil Sherman

da*******@yahoo.com wrote:
Running DB2 8.2 on AIX 5.2

I have a question on reorgs and reorgchk results. My reorg script is
using the db2reorgchk (which I understand has certain limitations) to
determine if a table or an index needs to be reorged. The presence of
an asterisk in the output for the table triggers a reorg of the table
using the clustered index if it has one...allow no access.

Then runstats

Then if the reorg was done, I do another reorgchk to see if the indexes
still need to be reorged.

If there is an asterisk in the indexes output, any of them, then I do a
reorg indexes all for that table
Then another 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

Jun 11 '06 #2
Thanks Phil
Phil Sherman wrote:
Have you considered the size of the table. When card increases,
eventually more than three levels will be needed for the index. The only
solutions to decrease the number of levels in the index is to increase
the size of the index page or decrease the number of rows in he table.
Increasing the index page size may run into the limit on how many rows
can be placed in the page.

Phil Sherman

da*******@yahoo.com wrote:
Running DB2 8.2 on AIX 5.2

I have a question on reorgs and reorgchk results. My reorg script is
using the db2reorgchk (which I understand has certain limitations) to
determine if a table or an index needs to be reorged. The presence of
an asterisk in the output for the table triggers a reorg of the table
using the clustered index if it has one...allow no access.

Then runstats

Then if the reorg was done, I do another reorgchk to see if the indexes
still need to be reorged.

If there is an asterisk in the indexes output, any of them, then I do a
reorg indexes all for that table
Then another 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


Jun 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Stevey | last post: by
3 posts views Thread by datapro01 | last post: by
22 posts views Thread by jdokos | last post: by
10 posts views Thread by glenn | last post: by
3 posts views Thread by rdudejr | last post: by
1 post views Thread by daiesy.ember | last post: by
reply views Thread by mmcsbell | last post: by
18 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.