Rebuilding Logical Files

470 pts.
Tags:
AS/400 administration
AS/400 database
Database management
IBM iSeries
iSeries database
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dcantwell
    Thank you very much Phil! That cleared everything up! Dave
    470 pointsBadges:
    report
  • Gilly400
    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.
    23,730 pointsBadges:
    report
  • Dcantwell
    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
    470 pointsBadges:
    report
  • WilsonAlano
    Dan, You don't need to rebuild LFs. The system will take care to maintain them! Wilson
    2,600 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following