How UNLOAD RELOAD or REORG handle DIRECT records. Will the sequence of the records be preserved after the RELOAD?
Article ID: 67863
Updated On:
Products
Issue/Introduction
If unloading an area with DIRECT records Will the sequence of the records be preserved after the RELOAD?
Environment
All supported releases
Resolution
When using the UNLOAD/RELOAD utility, the sequence of these records may not be preserved as it will depend if the DIRECT record's old page exists in the new area then it will attempt to replace it on that same page. The problem arises when the old page does not exist in the new page range at that point then the Direct record will be targeted to the low page of the new area, thus the records may not be in the same order in the area.
UNLOAD Usage documentation has a section called DIRECT records and their VIA clusters which states:
Since DIRECT records were placed on a specific page by a user, it may be difficult for the UNLOAD utility to determine where they should be placed in the new area. If the old page of a DIRECT record exists in the new area, the RELOAD attempts to place the occurrence on the same page. However, if the old page does not exist in the new page range, the occurrence targets to the low page of the new area.
If a DIRECT record owns a VIA record, the members store in their new area proportional to the position of their owner in its old area. If the owners and members reside in the same area and the page range was extended or changed, the VIA cluster may not be on the same page as the owner. If this is not acceptable, the user may want to consider using a user-written program to unload the database and the FASTLOAD utility to reload the area.
Additional Information
Feedback
