Record IDs 2 and 3 in a user database
Article ID: 38253
Updated On:
Products
Issue/Introduction
After a RESTRUCTURE, a PRINT SPACE report shows record IDs 2 and 3 that did not exist before the restructure. What are these and how can they be removed?
Environment
Release: All supported releases.
Resolution
The system records SR2 and SR3 indicate that some record occurrences were "relocated" during the restructure, because the increase in length resulted in the record not fitting back on its page.
The SR2 is a very small record stored at the original DBKEY as a placeholder. It contains the original record ID and the DBKEY of the SR3. The SR3 is the relocated record.
At some future time, when the area is readied in UPDATE mode, if a relocated record is accessed, and IDMS determines that it can now fit back on the original page, the SR2 and SR3 are deleted and the record goes back to its original page.
Unload/Reload or Reorg will also get rid of any SR2/SR3s.
If restructuring to increase record lengths and it is known that there are pages in the area with insufficient space to increase every occurrence of the records being increased, it is a good practice to first EXPAND PAGE the area to allow sufficient space on each page. This can help avoid relocated records during restructure. Then at some later date, unload/reload the area, taking it back to the optimal page size that was originally calculated for the records in the area and possibly expand the number of pages in the area as well.
Additional Information
Feedback
