SAVE RESTORE Query

0 pts.
Tags:
AS/400
DataCenter
We save all the files in a database and restore them to an existing (other) database that contains the same files. Our save 'saves' the access paths (logicals) an well as the pfs. Why do some of the files - only a few - in the 'to' database do access path rebuilds?
ASKED: November 14, 2006  6:43 AM
UPDATED: November 14, 2006  12:10 PM

Answer Wiki

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

If the access path rebuild option is other than *IMMED in the file description, the access path in the receiving library won’t be built until the file is opened.

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
  • Raddy59
    Howardk41 The maintenance is IMMED in both libraries - that's why we're fuddled?
    0 pointsBadges:
    report
  • Grumpfish
    I think the save made a decision not to save it as a rebuild would be quicker.
    0 pointsBadges:
    report
  • JDWWms
    You may also just being trying to access the files to soon after the restore procedure. The system must rebuild the access paths if a physical file and it's logicals are restored to a new library. But by default it can only work on them a few at a time in batch. You say only a few are rebuilding but I suspects the others are just finishing to fast to record with standard tools. If you turn on journalling I think you would find that they all rebuild. If you try to access a file right after the restore then the job you're running may be forecd to do the rebuild. You can force the rebuilds to happen by writing a program to just open them all but that may take longer than letting the system finish them. You might get better results by just copying the physical file members to the second library rather than saving and restoring them. Would only work if there are no format changes between processing.
    0 pointsBadges:
    report
  • WaltZ400
    If your logicals and physicals are in different libraries, the following help text from the SAVOBJ command might explain it. ATTENTION: If the based-on physical files and the logical files are in different libraries, the access paths are saved. However, if the logical files and the based-on physical files are in different libraries and the logical files or physical files do not exist at restore time (such as during disaster recovery or the files were deleted) the access paths are not restored. They are rebuilt. For the fastest possible restore operation for logical files, the logical files and the based-on physical files must be in the same library and must be saved at the same time.
    655 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