Home > IT Answers > AS/400 > I have saved library with access path yes, however after restoring data file and index , the index path again takes time to create why?
JohnsonMumbai
1,160 pts.
 I have saved library with access path yes, however after restoring data file and index , the index path again takes time to create why?
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
ASKED: February 2, 2010  1:14 PM
UPDATED: February 4, 2010  3:33 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  February 2, 2010  5:58 pm  by  CharlieBrowne   32,915 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,915 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

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

JohnsonMumbai
 1,160 pts.