Yes, if you are running a weekly table space reorg you may not need to reorg the indexes on that table space since...
those indexes are rebuilt every time the table space is reorganized.
However, for a very active application in a transaction processing environment you might want to see how disorganized the indexes become during the week. You might be able to get better performance if the indexes become disorganized quickly by reorganizing the index once (or perhaps more) during the period between table space reorgs. For example, if you reorg the table space every Saturday, you might want to examine the statistics for the indexes on Wednesday (or even Tuesday) to see how disorganized the indexes are. Look at the LEAFDIST, LEAFFAR, LEAFNEAR, and NLEVELS. As these stats get larger the index becomes less efficient. Maybe NLEVELS starts out at 3 on Saturday and is at 4 by Wednesday, then back to 3 after the reorg on Saturday. Reorganizing just the index on Wednesday night might help performance.
Dig Deeper on IBM DB2 management
Related Q&A from Craig S. Mullins
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.