Home > IT Answers > AS/400 > Rebuilding Logical Files
Dcantwell
465 pts.
 Rebuilding Logical Files
AS/400 database, AS/400 database administration, Database maintenance, iSeries, iSeries database, Logical File, Rebuilding Logical Files, Recompiling Logical Files
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?

Software/Hardware used:
ASKED: May 27, 2009  4:57 PM
UPDATED: May 27, 2009  9:08 PM
RELATED QUESTIONS
Answer Wiki:
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. Phil /////////////////////////////////////////////////////////////////////////////// This might help http://www.ibmsystemsmag.com/ibmi/june06/developer/7147p1.aspx http://www.itjungle.com/mpo/mpo102303-story03.html Command: EDTRBDAP 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. Phil
Last Wiki Answer Submitted:  May 27, 2009  8:44 pm  by  philpl1jb   44,220 pts.
All Answer Wiki Contributors:  philpl1jb   44,220 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thank you very much Phil!

That cleared everything up!

Dave

Dcantwell
 465 pts.
 

Hi,

If you reorganize a physical file the logical file is not rebuilt, but the access paths will be updated to reflect the new organization of the physical. (if maintenance is *IMMED)….

Regards,

Martin Gilbert.

Gilly400
 23,625 pts.
 

So what exactly does rebuilding do? And, how do you do it? Is it just a recompile of the logical file?

I have logical files that haven’t been rebuild in like 5 to 10 years. I figured they should be rebuilt

Dcantwell
 465 pts.
 

Dan,

You don’t need to rebuild LFs. The system will take care to maintain them!

Wilson

WilsonAlano
 2,385 pts.