I have saved library with access path yes, however after restoring data file and index , the index path again takes time to create why?

1160 pts.
Tags:
AS/400
Logical Files
I have saved library with access path yes, however after restoring data file and later the corresponding index separately. While iam able to see the relationship using DSPDBR, however when i do as sql select i find the selection takes time.

Do i have to restore both LF and PF in one command so that saved access paths need not be created? 



Software/Hardware used:
as400, LOGICAL FILES

Answer Wiki

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

If you save a PF and its access paths(LFs) and only restore the PF, the system will need to rebuild them. It cannot keep the current LFs with the new PF.
So, yes, you need to restore them all at one time.

Discuss This Question: 1  Reply

 
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
  • JohnsonMumbai
    Hi Charles, There are no logical files currently on the system. The backup of both pf and lf were taken together and restored one after the other, though not together in one command, also there is no change in the pf data after its restoration. Would it still create the access path again although the LF being restored contains the latest info as present in the PF as no data change has occurred between the period of PF restore and LF restore. Also what would be the advantage of storing LF's and PF's in differnet libraries. Johnson
    1,160 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