What does rebuilding a logical file do?
Is rebuilding the same as recompiling? Or, is it a separate process
How often should they be rebuilt?
If you reorganize a physical file, does that rebuild the logical files as well?
You do not need to rebuild the logicals
If the logical file attribute
Access path maintenance . . . . . . . . . . : MAINT *IMMED
If the attribute is *IMMED then the logical index is kept up-to-date.
If the attribute is *REBLD the system will rebuild the logical everytime it is used - it will not save the index.
- reduces work during updates to the physical - this logical will not be updated
- reduces space used
- processes as if it were an open query at the time of use
- appropriate for infrequent reports
- inappropriate for screen access
If the attribute is *DLY the system will wait until the next time the logical is used and
then decide to update the index or rebuild the index depending on the amount of change from last use.
This might help
Don't know if it helps with performance allows you to discover paths that need to be rebuilt because they are crupt and schedule rebuilds.
Last Wiki Answer Submitted: May 27, 2009 8:44 pm by philpl1jb44,220 pts.
All Answer Wiki Contributors: philpl1jb44,220 pts.